Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help Final P&L of Results Inform the final results and whether the results are favorable or unfavorable. Within discussion, be sure to provide the

Please help Final P&L of Results Inform the final results and whether the results are favorable or unfavorable. Within discussion, be sure to provide the definition of the Gross Profit Percentage and what this percentage represents for the amount of revenue this proposal will make. If there are areas within the budget that can be improved upon in terms of lowering costs, please discuss how this would be possible. results and state whether you think this is a good idea or not

image text in transcribedimage text in transcribed

Your company is competing for business in the computer mouse industry Prepare a sales, production, direct materials, and direct labor budget based on the following assumptions Assumptions Q2 1. Sales Projections Q1 10,000 Q4 17,000 Q4 25,000 2. Sales Price per Unit 5. Desired Ending Inventory 6. Beginning Inventory 15,000 $25.00 |5% of next quarters sales The same as the prior quarters ending inventory. 7. Material Needs 8. Material Costs 9. Material Desired Ending Inventory 10. Material Beginning Inventory 11. Labor Costs 12. Time to produce one mouse 0.05 Lb. per unit of plastic 2 per pound of plastic 5% of next months Sales The same as the previous quarters ending inventory. $20 per hour 0.25 hour lbs. lbs. Is it Worth It? Projected Sales (Revenue) Cost of Goods Sold - Material Costs - Labor Costs Gross Profit Calculation Projected Revenue - Projected Cost of Goods Sold Gross Profit Margin Calculation - (Revenue - COGS) / Revenue *100 Q1 $250,000 Q2 $375,000 1,075.00 1,509.00 53,750.00 75,500.00 54,825.00 77,009.00 $195,175 $297,991 78% 79% Q3 $425,000 1,739.00 2,484.00 87,000.00 124,250.00 88,739.00 126,734.00 $336,261 79% Q4 $625,000 $498,266 80%

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

More Books

Students also viewed these Accounting questions