Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Below are the budgeted and actual results for Angie's empanadas for April-September. Using the information given, create the income statement and CM per unit statement
Below are the budgeted and actual results for Angie's empanadas for April-September. Using the information given, create the income statement and CM per unit statement for her budgeted AND actual data (template provided below).
Angies Empanadas budgeted-Variable Costing income Statement | |||||||
April | May | June | July | August | September | ||
Sales | $3,450 | $4,025 | $5,175 | $5,750 | $7,475 | $12,650 | |
Price Per Unit | $11.50 | $11.50 | $11.50 | $11.50 | $11.50 | $11.50 | |
Units | 300 | 350 | 450 | 500 | 650 | 1100 | |
Sales | $3,450 | $4,025 | $5,175 | $5,750 | $7,475 | $12,650 | |
Less: Variable Cost | |||||||
Ingredients | |||||||
Labour | |||||||
Trays | |||||||
Utilities | |||||||
Deliveries | |||||||
Total Variable Cost | |||||||
Net Contribution margin | |||||||
Fixed Cost | |||||||
Rent | |||||||
Utilities | |||||||
Deliveries | |||||||
Total Fixed Cost | |||||||
Net Profit |
Contribution Margin budgetted per Unit | ||||||
April | May | June | July | August | September | |
Sales Per Unit | $11.50 | $11.50 | $11.50 | $11.50 | $11.50 | $11.50 |
Variable cost Per Unit | ||||||
Ingredients | ||||||
Labour | ||||||
Tray | ||||||
Utilities | ||||||
Deliveries | ||||||
Total Variable Cost | ||||||
Contribution Margin Per unit |
***please use the same format for actual
Table 1: SIX-MONTH BUDGET (APRIL-SEPTEMBER JUNE AUGUST 650 $7475 SEPTEMBER 1,100 $12,650 TOTAL 3,350 $38,525 APRIL MAY JULY 300 500 Trays sold Sales revenue Cost of sales 350 450 $3,450 $4,025 $5,175 $5,750 $725 1,035 90 1,000 121 650 $3,621 $(171) $1,087 1,552 135 1,000 131 800 $4,705 $470 $2,657 3,795 330 1,000 Ingredients Labor Trays Rent Utilities Delivery $845 1,208 105 1,000 125 700 $3,983 $42 $1,207 1,725 150 1,000 135 850 $5,067 $683 $1,570 2,243 195 1,000 146 1,000 $6.154 $1,321 $8,091 11,558 1.005 6,000 835 5,450 $32,939 $5,586 1450 $9409 $3,241 Total cost of sales Operating profit NOTE MIXED COSTS VARIABLE COST PER TRAY FIXED COST PER MONTH Utilities $0.07 $100 Delivery $1.00 $350Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started