70.2K

Verified Solution

Link Copied!

i simply just need to add to the yellow boxes with the information given

here is a bettwr close up of those numbers

On the tab are the following budgeted incomes and actual incomes: Satchmo's Custom Coffee Cups Satchmo's Custom Coffee Cups Master Budget Actual income For 2020 For the year ending December 31, 2020 Sales Volume (crutes) 12.000 crates Sales Volume (crates) 10,000 crates Sales Revenue $ 850.00 /crate $ 10,200,000 Sales Revenue $ 8,650,000 Less: Variable Costs $ 765.00 /crate $ 9.180,000 Less: Variable costs 7959.050 Contribution Margin $ 1,020,000 Contribution Margin $ 690,950 Less Fixed Costs less: Feed Costs Fixed Manufacturing $ 430,000 Fixed Manufacturing $ 435,000 Fred Selling S& Administrative 290,000 Fixed Selling S& Administrative 5 289,000 Total Fixed Cost 720,000 Total Fixed Cost 724,000 Operating Income $ 300,000 Operating Income/(loss) $ (83.050) $ The budget is based on the following assumptions: Satchmo's Custom Coffee Cups Budget Assumptions For 2000 Selling Price 5850,00/crate Bugeted Sales 12.000 crates Vedat Manfacturin Costa Direct Materials 25./orate $12.00/1 $100.00 crate Direct labor Merate $15.00/ $105.00/crate Variable Overhead crate $12000/000/crate Variable Manufacturing Cost per Crate $265.00erate Fred Fixed Manufacturing $ 4OXO Faed Selling Amistrative $20,000 Simply fill in the correct sales volume in crates along with the budgeted sales price, variable cost per unit and fixed costs. This will then automatically fill the performance report on the second tab, Manufacturing Cost Variances. $ 300,000 2 Operating Income 3 $ $ Satchmo's Custom Coffee Cups Flexible Budget For 2020 8 Sales Volume (crates) 9 Sales Revenue 0 Less: Variable Costs $ 1 Contribution Margin $ 22 Less: Fixed Costs 23 Fixed Manufacturing Fixed Selling S& Administrative 25 Total Fixed Cost 26 Operating Income $ 27 28 Satchmo's Custom Coffee Cups 29 Actual Income 30 For the year ending December 31, 2020 31 Sales Volume (crates) 10,000 crates 32 Sales Revenue $ 8,650,000 33 Less: Variable Costs $ 7,955,050 34 Contribution Margin $ 694,950 35 Less: Fixed Costs 36 Fixed Manufacturing $ 435,000 37 Fixed Selling S& Administrative $ 289.000 38 Total Fixed Cost $ 724,000 89 Operating Income/(loss) S (29.050) 40 41 42 43 apter 9 alve Ual learning project is the first tab ah the tab are the following budgeted incomes and a Satchmo's Custom Coffee Cups Master Budget For 2020 Sales Volume (crates) 12,000 crates Sales Voll Sales Revenue $ 850.00 /crate $ 10,200,000 Sales Rev. Less: Variable Costs $ 765.00 /crate $ 9,180,000 Less: Varia Contribution Margin $ 1,020,000 Contributie Less: Fixed Costs Less: Fixed Fixed Manufacturing $ 430,000 Fixed M Fixed Selling S& Administrative $ 290,000 Fixed Se Total Fixed Cost $ 720,000 Total F Operating Income $ 300,000 Operating 1 e budget is hased on the following accumntions. s and actual incomes: Satchmo's Custom Coffee Cups Actual Income For the year ending December 31, 2020 Sales Volume (crates) 10,000 crates 30 Sales Revenue $ 8,650,000 Less: Variable Costs $ 7,959,050 0 Contribution Margin $ 690,950 Less: Fixed Costs Fixed Manufacturing $ 435,000 Fixed Selling S& Administrative $ 289,000 00 Total Fixed Cost $ 724,000 00 Operating Income/(loss) $ (33,050) iu following assumptions: Satchmo's Custom Coffee Cups Budget Assumptions For 2020 Selling Price $ 850.00 /crate Budgeted Sales 12,000 crates Variable Manufacturing Costs Direct Materials 25 lb./crate $12.00/1b. $300.00 /crate Direct Labor 3 hr/crate $35.00/hr $105.00 /crate Variable Overhead 3 hr/crate $120.00/hr $ 360.00 /crate Variable Manufacturing Cost per Crate $ 765.00 /crate Fixed Costs Fixed Manufacturing $ 430,000 Fixed Selling & Administrative $ 290,000

Answer & Explanation Solved by verified expert

See Answer