Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can anyone help me with blanks? thanks. Fixed Costs Fixed Cost Items Rent Utilities Admin Costs Insurance $ $ $ $ Quarter 1 30,200.00 $
can anyone help me with blanks? thanks.
Fixed Costs Fixed Cost Items Rent Utilities Admin Costs Insurance $ $ $ $ Quarter 1 30,200.00 $ 3,650.00 $ 7,105.00 $ 2,790.00 $ Quarter 2 30,200.00 $ 3,650.00 $ 7,180.00 $ 2,720.00 $ Quarter 3 31,257.00 $ 3,650.00 $ 7,320.00 $ 2,790.00 $ Quarter 4 Quarterly Average 31,257.00 $ 30,728.50 3,650.00 $ 3,650.00 7,250.00 $ 7,213.75 2,720.00 $ 2,755.00 % of Total 69% 8% 16% 6% Quarterly Totals $ 43,745.00 $ 43,750.00 $ 45,017.00 $ 44,877.00 Total Fixed Costs $ 177,389.00 Highest Quarterly Admin Costs: Average Monthly Rent: Rent % Increase: $ $ 7,250.00 10,242.83 0.035 Labour Costs Labour Costs per hour $ 25.00 Labour Hours per Unit WB500 WB660 1.5 2.2 Please Note: This sheet is locked and cannot be altered in any way. The values can be used in calculations but you will need to click on them rather than using named ranges. 10% WB660 Sales Mix Unit Increments 70% 250 State Tax Federal Tax 5% 1000 Sales Volume in Units Total $ Sales Value Variable Costs Direct Material Direct Labor Other Vary-with-Unit Costs Sales Commissions Total Variable Costs $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $ Profit Before Tax (Contribution Margin - Fixed Costs) Income Tax State Tax Federal Tax Total Income Tax $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $ Profit after Tax % Profit (of Sales) Break-Even Analysis Line Chart Data Fixed Costs Total Costs Total $ Sales Value Fixed Costs Product Information Unit Sales Price Units Manufactured and Sold Sales Mix (% of total units sold) WB500 $305.00 5290 WB660 $455.00 3491 Vary-with-Revenue Costs Sales Commissions 3.5% Weighted Average Contribution Margin Break Even Units (weighted) WB500 WB660 Vary with Unit Costs Direct Material Direct Labor Other Vary-with-Unit Costs Total Vary with Unit Costs $15.85 $15.85 $17.13 $17.13 Break Even Variable Costs Direct Material Direct Labor Other Vary-with-Unit Costs Sales Commissions Total Variable Costs WB500 WB660 Break Even Analysis Contribution Margin Per Unit $0.00 Break Even Point in Units/Product Break Even in Sales Dollars Break Even Contribution Margin Break Even Profit Before Tax Labour caste UD Cived cocte RAM CVD Analysis Drofit Volume Caracast Invonton Bill of Materials 1 Product Decsription Price Each Quantity 1 4 1 1 1 8 2 3 Product 4 WB660 5 WB660 6 WB660 7 WB660 8 WB660 9 WB660 10 WB660 11 WB660 12 WB500 13 WB660 14 WB500 15 WB660 16 WB500 17 WB500 18 WB660 19 WB500 20 WB660 Part Code PX1004683 PX242979 PX373195 PX374089 PX374561 PX577199 PX723206 PX723541 PX723542 PX723557 PX723566 PX723593 PX723594 4 1 1 Total Price $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 4 1 8 2 4 1 PX723596 PX723742 PX723743 PX723745 2. 4. Fixed Costs Fixed Cost Items Rent Utilities Admin Costs Insurance $ $ $ $ Quarter 1 30,200.00 $ 3,650.00 $ 7,105.00 $ 2,790.00 $ Quarter 2 30,200.00 $ 3,650.00 $ 7,180.00 $ 2,720.00 $ Quarter 3 31,257.00 $ 3,650.00 $ 7,320.00 $ 2,790.00 $ Quarter 4 Quarterly Average 31,257.00 $ 30,728.50 3,650.00 $ 3,650.00 7,250.00 $ 7,213.75 2,720.00 $ 2,755.00 % of Total 69% 8% 16% 6% Quarterly Totals $ 43,745.00 $ 43,750.00 $ 45,017.00 $ 44,877.00 Total Fixed Costs $ 177,389.00 Highest Quarterly Admin Costs: Average Monthly Rent: Rent % Increase: $ $ 7,250.00 10,242.83 0.035 Labour Costs Labour Costs per hour $ 25.00 Labour Hours per Unit WB500 WB660 1.5 2.2 Please Note: This sheet is locked and cannot be altered in any way. The values can be used in calculations but you will need to click on them rather than using named ranges. 10% WB660 Sales Mix Unit Increments 70% 250 State Tax Federal Tax 5% 1000 Sales Volume in Units Total $ Sales Value Variable Costs Direct Material Direct Labor Other Vary-with-Unit Costs Sales Commissions Total Variable Costs $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $ Profit Before Tax (Contribution Margin - Fixed Costs) Income Tax State Tax Federal Tax Total Income Tax $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $ Profit after Tax % Profit (of Sales) Break-Even Analysis Line Chart Data Fixed Costs Total Costs Total $ Sales Value Fixed Costs Product Information Unit Sales Price Units Manufactured and Sold Sales Mix (% of total units sold) WB500 $305.00 5290 WB660 $455.00 3491 Vary-with-Revenue Costs Sales Commissions 3.5% Weighted Average Contribution Margin Break Even Units (weighted) WB500 WB660 Vary with Unit Costs Direct Material Direct Labor Other Vary-with-Unit Costs Total Vary with Unit Costs $15.85 $15.85 $17.13 $17.13 Break Even Variable Costs Direct Material Direct Labor Other Vary-with-Unit Costs Sales Commissions Total Variable Costs WB500 WB660 Break Even Analysis Contribution Margin Per Unit $0.00 Break Even Point in Units/Product Break Even in Sales Dollars Break Even Contribution Margin Break Even Profit Before Tax Labour caste UD Cived cocte RAM CVD Analysis Drofit Volume Caracast Invonton Bill of Materials 1 Product Decsription Price Each Quantity 1 4 1 1 1 8 2 3 Product 4 WB660 5 WB660 6 WB660 7 WB660 8 WB660 9 WB660 10 WB660 11 WB660 12 WB500 13 WB660 14 WB500 15 WB660 16 WB500 17 WB500 18 WB660 19 WB500 20 WB660 Part Code PX1004683 PX242979 PX373195 PX374089 PX374561 PX577199 PX723206 PX723541 PX723542 PX723557 PX723566 PX723593 PX723594 4 1 1 Total Price $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 4 1 8 2 4 1 PX723596 PX723742 PX723743 PX723745 2. 4Step 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