60.1K

Verified Solution

Link Copied!

Please let me know if you need any information. I just really need help getting started I'm having a true mental block

Table 1: Selected Financial Data (actual cost and revenue data for May 2018) Cost Category Behavior May 2018 Sales $766,667 Expenses: Raw Materials. Bakery Variable $327,934 labor : Administration Mixed $158,767 Salaries xd $41,367 Supplies Variable $3,833 Freight & Shipping-In Variable $4,907 Freight & Shipping-Out Variable $64,707 Utilities - Electricity Variable $9,813 Utilities - Gas (ovens) Variable $3,067 Water Variable $920 Repairs & Maintenance Fixed $4,293 Telephone & Internet Fixed $2,300 Co-owners' salary Fixed $25,300 Depreciation Expense: Plant Building 9,460 Pastry Machines 6,920 Mixers 7,832 Filling Equip. 7,471 Ovens 8,941 Warehouse Freezers 9,210 Total Depr. Fixed $49,834 Total Expenses $697,042 Operating Profit $69,625 Income Tax $22,280 Net operating income $47,345 Unit volume (30,980 whole, 33,520 variety) 64,500 Average Operating Assets $5,500,000 Minimum Rate of Return 8.00% 34,929 51,613 1 Raw materials: Crust ingredients (S.11) 7.120 Filling ingredients($4.65) 300,165 Packaging: Tins (S.08) 5,065 Labels (5.076) 4,916 boxes (5.11) 3.617 Plastic containers (S.22) 7.051 2 Labor: Production Supervisors Salaries Production line wages Packaging labor ($15.50/hr): whole pies variety pack Sanitation wages ( $15.50/hr) Shipping & receiving wages ($15.50/hr) 7,016 31,359 18,940 14,910 TO DILDO DEL PAU TICOLO DIODOTTOPP PLETIO J16 - B C D E F G H I K L M N O P Q | A 1 Job 2 Amounts ordered: 3 Whole pies 4 Variety pack 50 60 Whole Unit cost Total $ Variety Unit cost Total $ Units Units 7 8 Direct Material ! Direct Labor Hours Costihr Total $ Hours Costihr Total $ 11 12 15 Manufuring Overhead' Cost driver Cost'unit Total $ Cost drive Costiunit Total $ 16 21 Total cost for job per product 23 Cost per unit 25 Selling price per unit description 28 'Overhead Calculation -- desccription of method: 29 Total overhead cost overhead co cost drive cost driver rate 30 Sheet1 Select destination and press ENTER or choose Paste

Answer & Explanation Solved by verified expert

See Answer