4. Complete an example job cost sheet using the methods you describe. If you need to make assumptions in order to complete the sheet indicate on the sheet how the figures were estimated.
I need to find out how to do question number 4 involving the job cost sheet
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 a Administration Mixed $158,767 Salaries Fixed $41,367 Supplies Variable $3,833 Creich Freight & Shipping In Variable $4,907 Freight & Shipping Out Variable $64,707 Utilities - Electricity Variable $9,813 Utilities - Gas (ovens) Variable $3,067 Wate 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 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% Pastry Machines 34,929 51,613 1 Raw materials: Crust ingredients (S.11) 7,120 Filling ingredients($4.65) 300,165 Packaging: Tins (5.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 J16 X fic E F G H 1 J K L M N 0 P Q Whole pies Variety Unit cost Total $ Units Hours Costihr Total $ A B C D 1 1 Job # # 101 2 Amounts ordered: 3 50 4 Variety pack 60 5 6 Whole 7 Direct Material 7 Units Unit cost Total $ 8 9 10 11 Direct Labor Hours Cost/hr Total $ 12 13 14 15 Manufuring Overhead" Cost driver Cost'unit Total $ 16 17 18 19 20 21 Total cost for job per product 22 23 Cost per unit 24 25 Selling price per unit 26 27 28 'Overhead Calculation -- desccription of method: 29 Total overhead cost overhead co cost drive cost driver rate 30 Cost drive Cost/unit Total $ description Sheet1 (+ + Select destination and press ENTER or choose Paste
