accounting assignment

profileLeila@
anas.xlsx
Home>Business & Finance homework help>Accounting homework help>accounting assignment

Name & IDnumber

ID
Name: Last First 1 2 3 4 5 6 7 8 9
Husian Ans 0 0 0 0 7 4 7 6 5 29 4

Questionsfigures

Cost_Volume_Profit Analysis Input your M number in the Name &Mnumber spreadsheet and use the figures
& the behavior of costs
Price per trayF $11.83 $11.83
Over the past six months Angie
has incurred the following costs
and made the sales revenues
related to her empanada business 0.24 0.33 0.29 100 $ 130.00 $ 760.00
Empanada Labor Total Empanada Labor
Sales Ingredients Costs Trays Rent Utilities Delivery Quantity Profit Cost Sales Ingredients Costs Trays Rent Utilities Delivery Q profit
APRIL $ 3,549.00 $ 851.76 $ 1,171.17 $ 87.00 $ 1,100.00 $ 130.00 $ 760.00 300 $ (550.93) $ 4,099.93 APRIL $ 3,549.00 $ 851.76 $ 1,171.17 $ 87.00 $ 1,100.00 $ 130.00 $ 760.00 300 $ (550.93) 300
MAY $ 4,140.50 $ 993.72 $ 1,366.36 $ 101.50 $ 1,100.00 $ 134.00 $ 820.00 350 $ (375.09) $ 4,515.58 MAY $ 4,140.50 $ 993.72 $ 1,366.36 $ 101.50 $ 1,100.00 $ 134.00 $ 820.00 350 $ (375.09) 350
JUNE $ 5,323.50 $ 1,277.64 $ 1,756.75 $ 130.50 $ 1,100.00 $ 142.00 $ 940.00 450 $ (23.40) $ 5,346.89 JUNE $ 5,323.50 $ 1,277.64 $ 1,756.75 $ 130.50 $ 1,100.00 $ 142.00 $ 940.00 450 $ (23.40) 450
JULY $ 5,915.00 $ 1,419.60 $ 1,951.95 $ 145.00 $ 1,100.00 $ 146.00 $ 1,000.00 500 $ 152.45 $ 5,762.55 JULY $ 5,915.00 $ 1,419.60 $ 1,951.95 $ 145.00 $ 1,100.00 $ 146.00 $ 1,000.00 500 $ 152.45 500
AUGUST $ 7,689.50 $ 1,845.48 $ 2,537.53 $ 188.50 $ 1,100.00 $ 158.00 $ 1,180.00 650 $ 679.98 $ 7,009.51 AUGUST $ 7,689.50 $ 1,845.48 $ 2,537.53 $ 188.50 $ 1,100.00 $ 158.00 $ 1,180.00 650 $ 679.98 650
SEPTEMBER $ 13,013.00 $ 3,123.12 $ 4,294.29 $ 319.00 $ 1,100.00 $ 194.00 $ 1,720.00 1,100 $ 2,262.59 $ 10,750.41 SEPTEMBER $ 13,013.00 $ 3,123.12 $ 4,294.29 $ 319.00 $ 1,100.00 $ 194.00 $ 1,720.00 1100 $ 2,262.59 1100
Total $ 39,630.50 $ 9,511.32 $ 13,078.06 $ 971.50 $ 6,600.00 $ 904.00 $ 6,420.00 3,350 $ 2,145.61 $ 37,484.88
Variable cost per unit $ 2.84 $ 3.90 $ 0.29 $ - 0 $ 0.08 $ 1.20 $ 8.31
Fixed cost per month $ - 0 $ (0.00) $ 0.00 $ 1,100.00 $ 106.00 $ 400.00 $ 1,606
Answer the following questions: Using formulas and links Do not type in answers $ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.38 $ 2.34
$ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.32 $ 2.09
Month Angie first earns a profit? $ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.29 $ 2.00
Which months does Angie have a loss? $ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.24 $ 1.82
$ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.18 $ 1.56
Which items are:
Variable cost items? Ingredients Labor Trays VCu $ 0.08 $ 1.20
Mixed Cost items? Utilities Delivery FC 106 400
Fixed Cost item? Rent
Contribution Margin per tray? $3.52
Contribution Margin percentage? 29.73%
Angie's CVP formula per month Profit = $11.83 Q - $ 8.31 Q - $ 1,606
Break even Quantity 457
Break even Sales $ 5,402.20 Empanada Labor
Sales Ingredients Costs Trays Rent Utilities Delivery Q
Sales for target profit of $4,000 mo 1,594.02 units $ 18,857.23 $ 4,000.00 $ 1,000.00 $ 1,200.00 $ 100.00 $ 1,000.00 $ 140.00 $ 600.00 338.1234150465
$ 4,000 5,000.00 1,250.00 1,500.00 125.00 1,000.00 150.00 700.00 422.6542688081
Taxes Income 30% 3,000.00 750.00 900.00 75.00 1,000.00 130.00 500.00 253.5925612849
2,500.00 625.00 750.00 62.50 1,000.00 125.00 450.00 211.3271344041
Break even Quantity 457 4,500.00 1,125.00 1,350.00 112.50 1,000.00 145.00 650.00 380.3888419273
10,000.00 2,500.00 3,000.00 250.00 1,000.00 200.00 1,200.00 845.3085376162
Sales for target profit of $4,000 mo 2,081.46 units $ 24,623.67
$ 5,714.29
Please provide, in good form, an itemized Variable-Costing Income Statement for the six month period from April through September $ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.43 $ 2.53
(Do not show 6 income statements) $ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.38 $ 2.34
$ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.32 $ 2.09
Sales $ 39,630.50 $ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.29 $ 2.00
Minus Variable Costs $ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.24 $ 1.82
Ingredients $ 9,511.32
Labor 13,078.06
Trays 971.50 Vcu 0.08 1.2
Utilities 268.00 FC 106.00 400
Delivery 4,020.00
Total variable costs 27,848.88
Contribution Margin 11,781.61
Minus Fixed Costs
Rent 6,600.00 $11.83 Price 100% 457 BEq
Utilities 636.00 $ 1,606.00 8.31 Vcu 70%
Delivery 2,400.00 $3.52 Cmu 30% $ 5,402.20 BE$
Total Fixed Costs 9,636.00
Operating Income $ 2,145.61
What questions would you need to have answered to determine if Angie can reach her goal in the next six months?

Inputs

Assumptions 4th Quarter
Price
Sales $11.83
Quantity
October 1,554
November 1,772
December 2,214
January 2,214
February 2,214
Inputs
Direct Materials Assumptions Cash Flow Assumptions
Beginning Inventory Sales Cash collections
Ingrediants 0 Cash 35%
Trays 0 Credit 65% following month
Desired ending Inventory Uncollectable 0
Ingrediants 5%
Trays 50% Current cash balance September 30. $ 6,509.28
Account Receivable $ 8,458.45
Standard Costs (last 6 mos) per tray Cash Disbursements
Ingrediants $ 2.84 Ingrediants 100% following month
Trays $ 0.29 Trays 100% following month
Line of credit and desired cash balance
Direct Labor Assumptions Line of credit $ 20,000
Standard Costs (last 6 mos) per tray Desired Cash balance $ 10,000
$ 3.90 Interest rate/year 6%
Borrowing Increment $ 1,000
Overhead assumptions and rates Accounts Payable
Rates per tray Ingrediants $ 3,123.12
Utilities $ 0.08 Trays $ 319.00
Other accounts paid in the month
per month
Utilities $ 106
Rent $ 1,265 Finished Goods Inventory Quanitity
Beginning 0.00% 0
Selling & Administrative Costs Ending 6.00%
Rates per tray
Delivery $ 1.56
per month
Delivery $ 400 Included in monthly delivery costs
Advertising $ 500
Fixed Delivery Vehicle Depreciation
Donated Van (April 1) $ 9,400
years life 3
Salvage value $ 1,120
Accumulated depreciation $ 1,380
Value of invested capital
Cash $ 8,000
Van $ 9,400

Beginning Balance Sheet

Balance Sheet 30-Sep
Assets Liabilities & OE
Cash $ 6,509 AP $ 3,442.12
AR 8,458 Loan Payable
Inventory
Materials
FG -
Van 9,400 Invested capital 17,400
Accm Dep (1,380) Profit(loss) 2,146
Total Assets $ 22,987.73 Total L & OE $ 22,987.73

Sales & Cash Collections

Sales Budget
October November December Total
Quantity
Revenue
Cash Inflows
October November December
from Sept.
October
October
November
November
December
Totals
AR End

Production Budget

Production Budget
October November December January Quarter
Sales Budgeted
Desired Ending Inv
6% +
Total needs
Less BI -
Required Production

Materials budget

Direct Materials Budget
Inputs
October November December Quarter January
Required Production Units
Raw Material per
tray inputs x
Production needs
Desired ending Inv
Ingrediants +
Total needs
Less BI -
Ingrediants to
Purchase
Cost for ingrediants
Trays
October November December Quarter January
Required Production Units 0 0 0 0 2,214
Material per
Tray x 1 1 1 1 1
Production needs/lbs 0 0 0 0 2,214
Desired ending Inv
Trays + 0 0 1,107 1,107
Total needs 0 0 1,107 1,107
Less BI Trays - 0 0 0 13,000
Trays to purchase
Purchase 0 0 1,107 1,107
Cost for trays $ - $ - $ 321 $ 321

Cash Disbursements Materials

Cash Disbursements Materials
October November December Quarter
AP Beginning
October
100.0%
November
100.0%
December
Total Cash out Materials
AP ending

Direct Labor Budget

Direct Labor Budget
October November December Quarter
Unit to be produced 0 0 0 0
DL Cost per tray x $ 3.90 $ 3.90 $ 3.90 $ 3.90
Total DL Cost $ - $ - $ - $ -

MOH

Manufacturing Overhead
October November December Quarter
Budgeted Trays 0 0 0 0
VMOH Rate x $ 0.08 $ 0.08 $ 0.08 $ 0.08
VMOH $ - $ - $ - $ -
FMOH + 1,371 1,371 1,371 4,113
Total MOH 1,371 1,371 1,371 4,113
Less Depreciation -
Cash Disbursements for MOH $ 1,371 $ 1,371 $ 1,371 $ 4,113

S & A Expense

S & A Expense
October November December Quarter
Budgeted Sales/ Units 0 0 0 0
V S&A per unit x $ 1.56 $ 1.56 $ 1.56 $ 1.56
V S&A Expense $ - $ - $ - $ -
Fixed S&A Expense + 900 900 900 2,700
Total S&A 900 900 900 2,700
Depreciation - 230 230 230 690
Cash Out S&A $ 670 $ 670 $ 670 $ 2,010

Cash Budget

Cash Budget
October November December Quarter Loan Balance
Cash Balance Beginning
Add
Cash Collections
Total Available Cash
Less Disbursements
DM
DL
MOH
S&A
Equipment Purchases
Dividends
Total Disbursements
Avaiable minus Disburs
Desired cash balance
Excess(deficiency) of
Cash available 1 1 1
Borrowing
Repayments $ 45.00
Cash Balance, ending

COGM&COGS

VCOGM
October November December Quarter
DM
Beg Inv DM $ - $ - $ - $ -
Add: Purchases - - 321 321
Mat. Avail - - 321 $ 321
Deduct: end Inv DM - - 321 321
DM Used - - - -
DL - - - -
VMOH - - - 227
Total MFG Cost - - - -
Add: Beg WIP inv - - - -
Subtotal - - - -
Deduct: End WIP - - - - 0 Units EI
Cost of Goods manf. $ - $ - $ - $ - $ - 0 Cost/unit
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! $ - 0 EI Dec 31
VCOGS
October November December Quarter
VCOGM $ - $ - $ - $ -
Add Beg Inv finished goods - ERROR:#DIV/0! ERROR:#DIV/0! -
GAS - ERROR:#DIV/0! ERROR:#DIV/0! -
Deduct Ending FG Inv ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
V Cost of Goods Sold ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

Proforma IS

Income Statement
For the 3 months ending December 31
Sales $0.00
Less Variable Costs of goods sold
V S&A (Delivery)
Total Variable Costs
Contribution margin
Less Fixed Costs
FMOH
FS&A
Total Fixed Costs
Operating Income
Interest expense
Net Income

Ending Balance Sheet

Balance Sheet 31-Dec
Assets Liabilities & OE
Cash
AR
Inv
DM
FG
Van
Accm Dep
Total Assets $ - 0
OR
Assets Liabilities & OE
Cash $ - 0 $ -
AR - Loan payable 0
Inv
DM -
FG -
Van - 0 2,146
Accm Dep - Profit(loss) $ -
Total Assets $ - 0 $ 2,146

QuestionsfiguresSource

Cost_Volume_Profit Analysis Input your M number in the Name &Mnumber spreadsheet and use the figures
& the behavior of costs
Price per trayF $11.83 $11.83
Over the past six months Angie
has incurred the following costs
and made the sales revenues
related to her empanada business 0.24 0.33 0.29 100 $ 130.00 $ 760.00
Empanada Labor Empanada Labor
Sales Ingredients Costs Trays Rent Utilities Delivery Sales Ingredients Costs Trays Rent Utilities Delivery Q profit
APRIL $ 3,549.00 $ 851.76 $ 1,171.17 $ 87.00 $ 1,100.00 $ 130.00 $ 760.00 APRIL $ 3,549.00 $ 851.76 $ 1,171.17 $ 87.00 $ 1,100.00 $ 130.00 $ 760.00 300 $ (550.93) 300
MAY $ 4,140.50 $ 993.72 $ 1,366.36 $ 101.50 $ 1,100.00 $ 134.00 $ 820.00 MAY $ 4,140.50 $ 993.72 $ 1,366.36 $ 101.50 $ 1,100.00 $ 134.00 $ 820.00 350 $ (375.09) 350
JUNE $ 5,323.50 $ 1,277.64 $ 1,756.75 $ 130.50 $ 1,100.00 $ 142.00 $ 940.00 JUNE $ 5,323.50 $ 1,277.64 $ 1,756.75 $ 130.50 $ 1,100.00 $ 142.00 $ 940.00 450 $ (23.40) 450
JULY $ 5,915.00 $ 1,419.60 $ 1,951.95 $ 145.00 $ 1,100.00 $ 146.00 $ 1,000.00 JULY $ 5,915.00 $ 1,419.60 $ 1,951.95 $ 145.00 $ 1,100.00 $ 146.00 $ 1,000.00 500 $ 152.45 500
AUGUST $ 7,689.50 $ 1,845.48 $ 2,537.53 $ 188.50 $ 1,100.00 $ 158.00 $ 1,180.00 AUGUST $ 7,689.50 $ 1,845.48 $ 2,537.53 $ 188.50 $ 1,100.00 $ 158.00 $ 1,180.00 650 $ 679.98 650
SEPTEMBER $ 13,013.00 $ 3,123.12 $ 4,294.29 $ 319.00 $ 1,100.00 $ 194.00 $ 1,720.00 SEPTEMBER $ 13,013.00 $ 3,123.12 $ 4,294.29 $ 319.00 $ 1,100.00 $ 194.00 $ 1,720.00 1100 $ 2,262.59 1100
Answer the following questions: Using formulas and links Do not type in answers $ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.38 $ 2.34
$ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.32 $ 2.09
Month Angie first earns a profit? $ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.29 $ 2.00
Which months does Angie have a loss? $ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.24 $ 1.82
$ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.18 $ 1.56
Which items are: TVCu TFCM Cmu/% Beq/$
Variable cost items? VCu $ 0.08 $ 1.20 $ 8.31 $3.52 457
Mixed Cost items? FC 106 400 $ 1,606.00 29.73% $ 5,402.20
Fixed Cost item?
Contribution Margin per tray?
Contribution Margin percentage?
CVP formula per month
Break even Quantity
Break even Sales Empanada Labor
Sales Ingredients Costs Trays Rent Utilities Delivery Q
Sales for target profit of $4,000 mo $ 4,000.00 $ 1,000.00 $ 1,200.00 $ 100.00 $ 1,000.00 $ 140.00 $ 600.00 338.1234150465
5,000.00 1,250.00 1,500.00 125.00 1,000.00 150.00 700.00 422.6542688081
Taxes Income 30% 3,000.00 750.00 900.00 75.00 1,000.00 130.00 500.00 253.5925612849
2,500.00 625.00 750.00 62.50 1,000.00 125.00 450.00 211.3271344041
Break even Quantity 4,500.00 1,125.00 1,350.00 112.50 1,000.00 145.00 650.00 380.3888419273
10,000.00 2,500.00 3,000.00 250.00 1,000.00 200.00 1,200.00 845.3085376162
Sales for target profit of $4,000 mo
Please provide a detailed Variable-Costing Income Statement for the six month period from April through September $ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.43 $ 2.53
$ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.38 $ 2.34
$ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.32 $ 2.09
$ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.29 $ 2.00
$ 2.84 $ 3.90 $ 0.29 $ 1,100.00 $ 0.24 $ 1.82
Vcu 0.08 1.2
FC 106.00 400
$11.83 Price 100% 457 BEq
$ 1,606.00 8.31 Vcu 70%
$3.52 Cmu 30% $ 5,402.20 BE$
What questions would you need to have answered to determine if Angie can reach her goal in the next six months?