Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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 $350

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Analysis With Microsoft Excel

Authors: Conrad Carlberg

3rd Edition

0789736640, 9780789736642

More Books