70.2K

Verified Solution

Link Copied!

Class PEx Keating X M MHE R X The SalX 2 and a X MInbox engatx CFRWGy-T9LY1sBaydKhb_DUMIFO7mT8SORUYE/edit ens Help Last edit was seconds ago al 11 + BIUA Iuli JU 5 15 15 Use the spreadsheet as a basis to build your own spreadsheet. It is a protected spreadsheet and cannot be changed to student needs. Please make your own spreadsheet, but use this as a way to start Required - Name of Company, Name of Product, 3 Direct materials with name of material, amount used per unit price per unit for each of the 3 materials and a total materials price per unit, 2 labor departments with the name of the department, wages for the department, time used for department and price per unit for each department and a total labor price, 5 separate items listed in factory overhead with at least 2 having a variable portion per unit and all having a fixed portion, Selling expenses with at least 1 having a variable portion per unit and the other 3 having a fixed portion General or administrative expenses with at least 1 having a variable portion per unit and the other 3 having a fixed. Total fixed costs and variable costs per unit. Expected sales, selling price per unit, expected profit, contribution margin, contribution margin ratio, break even units, break even sales, target profit unit, target profit sales, a data table similar to the one on the second sheet of the workbook, and a chart MacBook Pro CYP Varia Durah TY Property $3.00 $1.35 28 soas 16.00 $3.13 $5.95 $0.00 52400 $52.50 2 hour 51300 $15.00 read M 2.40 1.50 0.85 $125,000 $48.000 556.500 $120,000 075 297.000 147.500 10,200 1.25 187.000 12.300 15,000 51,0040 59.33 node Selepre per 1,000,000 $250.00 $200.000 FORMULA1 FORMULA FORMULAS FORMULA artes de toi FORMULAS FORMULAG Mededete FORMULAY 819 fx Chart C 0 H M N C-V-P GRAPH $300.000 13.000.00 $2,500,000 10 11 12 52.000.000 11,500.00 $1.000.000 5600.000 16 15 16 10 0 16000 LOCO 30000 20000 Sales Volume units) 19 20 Data Table V. Conti 0 22 23 24 25 26 10,000 560000 30.0001600000 1120000 120.000 2400000 1610000 160.000 12000007240000 F.Com I Cott 560000 300000 500000 1060000 500000 1630000 500000 2180000 5000002740000 78 31 32 33 36 37 38 39 40 42 Information CVP Graph Fireble Budget Income Statemen Budots Vans Average: 984000 Count: 32 Paste BI lili Merge & Center $ -% Conditional Formatting Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. 814 G M Sales Variable Expenses Contribution Man Feed Expenses Net Income 0 E Income Statement 500.000 750.000 1,000,000 1,250.000 1,500,000 $125,000,000 $187.500,000 $250,000,000 $312.500.000 $375,000,000 $49.165.000 573.747.500 598,330.000 $122.912.500 $147,495,000 $75,835.000 $113,757.500 $151,670,000 $189,587,500 $227,505,000 51,024.500 $1,024,500 51.024.500 $1.024,500 51,024.500 $74,810.500 $112.728.000 $150,545 500 5185 563.000 $226,450.500 14 15 15 17 23 25 27 21 30 31 32 35 39 40 41 CVP ON Flowe Budget Income Statemen Budget Winance Paste Merge & Center $% % Conditional Form Formatting as Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates, 123 C N 1 Sal Budget Production Budget Direct Materials widget Direct Labor Budget Factory Overhead Budget 4 Cost of Goods Sold het 5 7 Budged Income Statement 1 10 11 15 16 11 19 22 23 [ 26 27 29 31 34 35 29 40 Innamon exible Budget Income statemen Budgets Vrance UPPS, vomonts, Choose Check for Updates A7 C D L M N 0 P a 8 Direct Materials Quantity Direct Materials Price Direct Libor Rate Direct Labor Time Variable Factory Overhead Pred Factory Overhead 10 14 15 17 18 20 22 23 26 30 Budgets Varianes Class PEx Keating X M MHE R X The SalX 2 and a X MInbox engatx CFRWGy-T9LY1sBaydKhb_DUMIFO7mT8SORUYE/edit ens Help Last edit was seconds ago al 11 + BIUA Iuli JU 5 15 15 Use the spreadsheet as a basis to build your own spreadsheet. It is a protected spreadsheet and cannot be changed to student needs. Please make your own spreadsheet, but use this as a way to start Required - Name of Company, Name of Product, 3 Direct materials with name of material, amount used per unit price per unit for each of the 3 materials and a total materials price per unit, 2 labor departments with the name of the department, wages for the department, time used for department and price per unit for each department and a total labor price, 5 separate items listed in factory overhead with at least 2 having a variable portion per unit and all having a fixed portion, Selling expenses with at least 1 having a variable portion per unit and the other 3 having a fixed portion General or administrative expenses with at least 1 having a variable portion per unit and the other 3 having a fixed. Total fixed costs and variable costs per unit. Expected sales, selling price per unit, expected profit, contribution margin, contribution margin ratio, break even units, break even sales, target profit unit, target profit sales, a data table similar to the one on the second sheet of the workbook, and a chart MacBook Pro CYP Varia Durah TY Property $3.00 $1.35 28 soas 16.00 $3.13 $5.95 $0.00 52400 $52.50 2 hour 51300 $15.00 read M 2.40 1.50 0.85 $125,000 $48.000 556.500 $120,000 075 297.000 147.500 10,200 1.25 187.000 12.300 15,000 51,0040 59.33 node Selepre per 1,000,000 $250.00 $200.000 FORMULA1 FORMULA FORMULAS FORMULA artes de toi FORMULAS FORMULAG Mededete FORMULAY 819 fx Chart C 0 H M N C-V-P GRAPH $300.000 13.000.00 $2,500,000 10 11 12 52.000.000 11,500.00 $1.000.000 5600.000 16 15 16 10 0 16000 LOCO 30000 20000 Sales Volume units) 19 20 Data Table V. Conti 0 22 23 24 25 26 10,000 560000 30.0001600000 1120000 120.000 2400000 1610000 160.000 12000007240000 F.Com I Cott 560000 300000 500000 1060000 500000 1630000 500000 2180000 5000002740000 78 31 32 33 36 37 38 39 40 42 Information CVP Graph Fireble Budget Income Statemen Budots Vans Average: 984000 Count: 32 Paste BI lili Merge & Center $ -% Conditional Formatting Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. 814 G M Sales Variable Expenses Contribution Man Feed Expenses Net Income 0 E Income Statement 500.000 750.000 1,000,000 1,250.000 1,500,000 $125,000,000 $187.500,000 $250,000,000 $312.500.000 $375,000,000 $49.165.000 573.747.500 598,330.000 $122.912.500 $147,495,000 $75,835.000 $113,757.500 $151,670,000 $189,587,500 $227,505,000 51,024.500 $1,024,500 51.024.500 $1.024,500 51,024.500 $74,810.500 $112.728.000 $150,545 500 5185 563.000 $226,450.500 14 15 15 17 23 25 27 21 30 31 32 35 39 40 41 CVP ON Flowe Budget Income Statemen Budget Winance Paste Merge & Center $% % Conditional Form Formatting as Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates, 123 C N 1 Sal Budget Production Budget Direct Materials widget Direct Labor Budget Factory Overhead Budget 4 Cost of Goods Sold het 5 7 Budged Income Statement 1 10 11 15 16 11 19 22 23 [ 26 27 29 31 34 35 29 40 Innamon exible Budget Income statemen Budgets Vrance UPPS, vomonts, Choose Check for Updates A7 C D L M N 0 P a 8 Direct Materials Quantity Direct Materials Price Direct Libor Rate Direct Labor Time Variable Factory Overhead Pred Factory Overhead 10 14 15 17 18 20 22 23 26 30 Budgets Varianes

Answer & Explanation Solved by verified expert

See Answer