accounting assignment

profileLeila@
angies_empanadasbudgetf16wmba_1.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
Gedjeyan Stephanie 0 0 0 0 5 6 6 5 1 23 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.77 $11.77
Over the past six months Angie
has incurred the following costs
and made the sales revenues
related to her empanada business 0.26 0.34 0.3 -100 $ 135.00 $ 694.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,531.00 $ 918.06 $ 1,200.54 $ 90.00 $ 900.00 $ 135.00 $ 694.00 300 $ (406.60) $ 3,937.60 APRIL $ 3,531.00 $ 918.06 $ 1,200.54 $ 90.00 $ 900.00 $ 135.00 $ 694.00 300 $ (406.60) 300
MAY $ 4,119.50 $ 1,071.07 $ 1,400.63 $ 105.00 $ 900.00 $ 140.00 $ 744.00 350 $ (241.20) $ 4,360.70 MAY $ 4,119.50 $ 1,071.07 $ 1,400.63 $ 105.00 $ 900.00 $ 140.00 $ 744.00 350 $ (241.20) 350
JUNE $ 5,296.50 $ 1,377.09 $ 1,800.81 $ 135.00 $ 900.00 $ 150.00 $ 844.00 450 $ 89.60 $ 5,206.90 JUNE $ 5,296.50 $ 1,377.09 $ 1,800.81 $ 135.00 $ 900.00 $ 150.00 $ 844.00 450 $ 89.60 450
JULY $ 5,885.00 $ 1,530.10 $ 2,000.90 $ 150.00 $ 900.00 $ 155.00 $ 894.00 500 $ 255.00 $ 5,630.00 JULY $ 5,885.00 $ 1,530.10 $ 2,000.90 $ 150.00 $ 900.00 $ 155.00 $ 894.00 500 $ 255.00 500
AUGUST $ 7,650.50 $ 1,989.13 $ 2,601.17 $ 195.00 $ 900.00 $ 170.00 $ 1,044.00 650 $ 751.20 $ 6,899.30 AUGUST $ 7,650.50 $ 1,989.13 $ 2,601.17 $ 195.00 $ 900.00 $ 170.00 $ 1,044.00 650 $ 751.20 650
SEPTEMBER $ 12,947.00 $ 3,366.22 $ 4,401.98 $ 330.00 $ 900.00 $ 215.00 $ 1,494.00 1,100 $ 2,239.80 $ 10,707.20 SEPTEMBER $ 12,947.00 $ 3,366.22 $ 4,401.98 $ 330.00 $ 900.00 $ 215.00 $ 1,494.00 1100 $ 2,239.80 1100
Total $ 39,429.50 $ 10,251.67 $ 13,406.03 $ 1,005.00 $ 5,400.00 $ 965.00 $ 5,714.00 3,350 $ 2,687.80 $ 36,741.70
Variable cost per unit $ 3.06 $ 4.00 $ 0.30 $ - 0 $ 0.10 $ 1.00 $ 8.46
Fixed cost per month $ (0.00) $ - 0 $ - 0 $ 900.00 $ 105.00 $ 394.00 $ 1,399
Answer the following questions: Using formulas and links Do not type in answers $ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.40 $ 2.13
$ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.33 $ 1.88
Month Angie first earns a profit? $ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.31 $ 1.79
Which months does Angie have a loss? $ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.26 $ 1.61
$ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.20 $ 1.36
Which items are:
Variable cost items? Ingredients Labor Trays VCu $ 0.10 $ 1.00
Mixed Cost items? Utilities Delivery FC 105 394
Fixed Cost item? Rent
Contribution Margin per tray? $3.31
Contribution Margin percentage? 28.11%
Angie's CVP formula per month Profit = $11.77 Q - $ 8.46 Q - $ 1,399
Break even Quantity 423
Break even Sales $ 4,977.70 Empanada Labor
Sales Ingredients Costs Trays Rent Utilities Delivery Q
Sales for target profit of $4,000 mo 1,632.10 units $ 19,209.86 $ 4,000.00 $ 1,000.00 $ 1,200.00 $ 100.00 $ 1,000.00 $ 140.00 $ 600.00 339.847068819
$ 4,000 5,000.00 1,250.00 1,500.00 125.00 1,000.00 150.00 700.00 424.8088360238
Taxes Income 30% 3,000.00 750.00 900.00 75.00 1,000.00 130.00 500.00 254.8853016143
2,500.00 625.00 750.00 62.50 1,000.00 125.00 450.00 212.4044180119
Break even Quantity 423 4,500.00 1,125.00 1,350.00 112.50 1,000.00 145.00 650.00 382.3279524214
10,000.00 2,500.00 3,000.00 250.00 1,000.00 200.00 1,200.00 849.6176720476
Sales for target profit of $4,000 mo 2,150.33 units $ 25,309.36
$ 5,714.29
Please provide, in good form, an itemized Variable-Costing Income Statement for the six month period from April through September $ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.45 $ 2.31
(Do not show 6 income statements) $ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.40 $ 2.13
$ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.33 $ 1.88
Sales $ 39,429.50 $ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.31 $ 1.79
Minus Variable Costs $ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.26 $ 1.61
Ingredients $ 10,251.67
Labor 13,406.03
Trays 1,005.00 Vcu 0.1 1
Utilities 335.00 FC 105.00 394
Delivery 3,350.00
Total variable costs 28,347.70
Contribution Margin 11,081.80
Minus Fixed Costs
Rent 5,400.00 $11.77 Price 100% 423 BEq
Utilities 630.00 $ 1,399.00 8.46 Vcu 72%
Delivery 2,364.00 $3.31 Cmu 28% $ 4,977.70 BE$
Total Fixed Costs 8,394.00
Operating Income $ 2,687.80
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.77
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. $ 7,348.47
Account Receivable $ 8,415.55
Standard Costs (last 6 mos) per tray Cash Disbursements
Ingrediants $ 3.06 Ingrediants 100% following month
Trays $ 0.30 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
$ 4.00 Interest rate/year 6%
Borrowing Increment $ 1,000
Overhead assumptions and rates Accounts Payable
Rates per tray Ingrediants $ 3,366.22
Utilities $ 0.10 Trays $ 330.00
Other accounts paid in the month
per month
Utilities $ 105
Rent $ 1,035 Finished Goods Inventory Quanitity
Beginning 0.00% 0
Selling & Administrative Costs Ending 6.00%
Rates per tray
Delivery $ 1.30
per month
Delivery $ 394 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 $ 7,348 AP $ 3,696.22
AR 8,416 Loan Payable
Inventory
Materials
FG -
Van 9,400 Invested capital 17,400
Accm Dep (1,380) Profit(loss) 2,688
Total Assets $ 23,784.02 Total L & OE $ 23,784.02

Sales & Cash Collections

Sales Budget
October November December Total January
Quantity 1,554 1,772 2,214 5,540 2214.45
$11.77 $11.77 $11.77 $11.77 $11.77
Revenue $18,290.58 $20,851.26 $26,064.08 $65,205.92 $26,064.08
Cash Inflows
October November December Oct-Dec totals
from Sept. $8,415.55 $8,415.55
October 35% $ 6,401.70
$18,290.58
October 65% $11,888.88
November $7,297.94
November $13,553.32
December $9,122.43 $ 16,941.65 $ 26,064.08
Totals $ 14,817.25 $ 19,186.82 $ 22,675.75 $ 16,941.65 $ 73,621.47
AR End $ 16,941.65
AR is the credit sales in decemeber (amount *65%)

Production Budget

Production Budget
October November December January Quarter
Sales Budgeted 1,554 1,772 2,214 2,214 7,754
Desired Ending Inv
6% + 106 133 133 465 837
Total needs 1,660 1,904 2,347 2,680 8,592
Less BI - 0 106 133 133 0
Required Production 1,660 1,798 2,214 2,547 8,592

Materials budget

Direct Materials Budget
Inputs
October November December Quarter January
Required Production Units 1,660 1,798 2,214 8,592 2,547
Raw Material per
tray inputs x
Production needs
Desired ending Inv
Ingrediants +
Total needs
Less BI -
Ingrediants to
Purchase
Cost for ingrediants 3.06 3.06 3.06 3.06
Trays
October November December Quarter January
Required Production Units 1,660 1,798 2,214 5,673 2,214
Material per
Tray x 1 1 1 1 1
Production needs/lbs 1,660 1,798 2,214 5,673 2,214
Desired ending Inv
Trays + 899 1,107 1,107 1,107
Total needs 2,559 2,905 3,322 8,786
Less BI Trays - 0 899 1,107 13,000
Trays to purchase
Purchase 2,559 2,006 2,214 6,780
Cost for trays $ 768 $ 602 $ 664 $ 2,034

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 1,660 1,798 2,214 5,673
DL Cost per tray x $ 4.00 $ 4.00 $ 4.00 $ 4.00
Total DL Cost $ 6,644 $ 7,196 $ 8,862 $ 22,702

MOH

Manufacturing Overhead
October November December Quarter
Budgeted Trays 1,660 1,798 2,214 5,673
VMOH Rate x $ 0.10 $ 0.10 $ 0.10 $ 0.10
VMOH $ 166 $ 180 $ 221 $ 567
FMOH + 1,140 1,140 1,140 3,420
Total MOH 1,306 1,320 1,361 3,987
Less Depreciation - - - - -
Cash Disbursements for MOH $ 1,306 $ 1,320 $ 1,361 $ 3,987

S & A Expense

S & A Expense
October November December Quarter
Budgeted Sales/ Units 1,554 1,772 2,214 5,540
V S&A per unit x $ 1.30 $ 1.30 $ 1.30 $ 1.30
V S&A Expense $ 2,020 $ 2,303 $ 2,879 $ 7,202
Fixed S&A Expense + 894 894 894 2,682
Total S&A 2,914 3,197 3,773 9,884
Depreciation - 230 230 230 690
Cash Out S&A $ 2,684 $ 2,967 $ 3,543 $ 9,194

Cash Budget

Cash Budget
October November December Quarter Loan Balance
Cash Balance Beginning balance sheet
Add
Cash Collections sales and cash collections
Total Available Cash
Less Disbursements
DM
DL
MOH
S&A
Equipment Purchases - - - - -
Dividends - - - - -
Total Disbursements
Avaiable minus Disburs difference between cash and disbursements\
Desired cash balance $ 10,000 $ 10,000 $ 10,000 $ 10,000
Excess(deficiency) of
Cash available 1 1 1
Borrowing
Repayments $ 45.00
Cash Balance, ending available minus disumbursement + 2000
1/2 % per monthh interest

COGM&COGS

VCOGM
October November December Quarter
DM
Beg Inv DM $ - $ 270 $ 332 $ -
Add: Purchases 771 605 667 2,043
Mat. Avail 771 875 1,000 $ 2,043
Deduct: end Inv DM 270 332 332 332
DM Used 501 543 667 1,711
DL 6,644 7,196 8,862 22,702
VMOH 166 180 221 227
Total MFG Cost 7,311 7,918 9,751 24,980
Add: Beg WIP inv - - - -
Subtotal 7,311 7,918 9,751 24,980
Deduct: End WIP - - - - 465 Units EI
Cost of Goods manf. $ 7,311 $ 7,918 $ 9,751 $ 24,980 $ 4.40 Cost/unit
$ 4.40 $ 4.40 $ 4.40 $ 2,048.77 EI Dec 31
VCOGS
October November December Quarter
VCOGM $ 7,311 $ 7,918 $ 9,751 $ 24,980
Add Beg Inv finished goods - 468 585 -
GAS 7,311 8,386 10,336 24,980
Deduct Ending FG Inv 468 585 585 585
V Cost of Goods Sold $ 6,843 $ 7,801 $ 9,751 $ 24,395
quarterly in materials budget
add cost for ingredients + cost of trays purchases
quarter ingredients *price per tray inventory
# of trays *cost per tray

Proforma IS

Income Statement
For the 3 months ending December 31
Sales $11.77
Less Variable Costs of goods sold on cogm & cogs
V S&A (Delivery)
Total Variable Costs
Contribution margin
Less Fixed Costs
FMOH oh budget
FS&A oh budget
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,688
Accm Dep - Profit(loss) $ -
Total Assets $ - 0 $ 2,688

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.77 $11.77
Over the past six months Angie
has incurred the following costs
and made the sales revenues
related to her empanada business 0.26 0.34 0.3 -100 $ 135.00 $ 694.00
Empanada Labor Empanada Labor
Sales Ingredients Costs Trays Rent Utilities Delivery Sales Ingredients Costs Trays Rent Utilities Delivery Q profit
APRIL $ 3,531.00 $ 918.06 $ 1,200.54 $ 90.00 $ 900.00 $ 135.00 $ 694.00 APRIL $ 3,531.00 $ 918.06 $ 1,200.54 $ 90.00 $ 900.00 $ 135.00 $ 694.00 300 $ (406.60) 300
MAY $ 4,119.50 $ 1,071.07 $ 1,400.63 $ 105.00 $ 900.00 $ 140.00 $ 744.00 MAY $ 4,119.50 $ 1,071.07 $ 1,400.63 $ 105.00 $ 900.00 $ 140.00 $ 744.00 350 $ (241.20) 350
JUNE $ 5,296.50 $ 1,377.09 $ 1,800.81 $ 135.00 $ 900.00 $ 150.00 $ 844.00 JUNE $ 5,296.50 $ 1,377.09 $ 1,800.81 $ 135.00 $ 900.00 $ 150.00 $ 844.00 450 $ 89.60 450
JULY $ 5,885.00 $ 1,530.10 $ 2,000.90 $ 150.00 $ 900.00 $ 155.00 $ 894.00 JULY $ 5,885.00 $ 1,530.10 $ 2,000.90 $ 150.00 $ 900.00 $ 155.00 $ 894.00 500 $ 255.00 500
AUGUST $ 7,650.50 $ 1,989.13 $ 2,601.17 $ 195.00 $ 900.00 $ 170.00 $ 1,044.00 AUGUST $ 7,650.50 $ 1,989.13 $ 2,601.17 $ 195.00 $ 900.00 $ 170.00 $ 1,044.00 650 $ 751.20 650
SEPTEMBER $ 12,947.00 $ 3,366.22 $ 4,401.98 $ 330.00 $ 900.00 $ 215.00 $ 1,494.00 SEPTEMBER $ 12,947.00 $ 3,366.22 $ 4,401.98 $ 330.00 $ 900.00 $ 215.00 $ 1,494.00 1100 $ 2,239.80 1100
Answer the following questions: Using formulas and links Do not type in answers $ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.40 $ 2.13
$ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.33 $ 1.88
Month Angie first earns a profit? $ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.31 $ 1.79
Which months does Angie have a loss? $ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.26 $ 1.61
$ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.20 $ 1.36
Which items are: TVCu TFCM Cmu/% Beq/$
Variable cost items? VCu $ 0.10 $ 1.00 $ 8.46 $3.31 423
Mixed Cost items? FC 105 394 $ 1,399.00 28.11% $ 4,977.70
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 339.847068819
5,000.00 1,250.00 1,500.00 125.00 1,000.00 150.00 700.00 424.8088360238
Taxes Income 30% 3,000.00 750.00 900.00 75.00 1,000.00 130.00 500.00 254.8853016143
2,500.00 625.00 750.00 62.50 1,000.00 125.00 450.00 212.4044180119
Break even Quantity 4,500.00 1,125.00 1,350.00 112.50 1,000.00 145.00 650.00 382.3279524214
10,000.00 2,500.00 3,000.00 250.00 1,000.00 200.00 1,200.00 849.6176720476
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 $ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.45 $ 2.31
$ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.40 $ 2.13
$ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.33 $ 1.88
$ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.31 $ 1.79
$ 3.06 $ 4.00 $ 0.30 $ 900.00 $ 0.26 $ 1.61
Vcu 0.1 1
FC 105.00 394
$11.77 Price 100% 423 BEq
$ 1,399.00 8.46 Vcu 72%
$3.31 Cmu 28% $ 4,977.70 BE$
What questions would you need to have answered to determine if Angie can reach her goal in the next six months?