Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please !!,please help me explain and write (answer in detail with paragraphs )! I superb appreciate your time and help. Your proposal is as follows:

Please !!,please help me explain and write (answer in detail with paragraphs )! I superb appreciate your time and help.

Your proposal is as follows:

We can produce 62,000 mice in the first quarter of the year and add $1,550,000 in revenue!

  • Sales Forecast What was your initial sales forecast?
  • Production Forecast After completing the Production budget, inform your boss of the results. Discuss how you arrived at your results.

image text in transcribedimage text in transcribedimage 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. Units Sales Price Total Sales Sales Budget Expected Sales in Units Q1 Q2 Q3 17,000 10,000 15,000 $25 $25 $25 $250,000 $375,000 $425,000 Q4 25,000 $25 $625,000 Production Budget Expected number of goods to be produced to meet the sales projection What you need: Sales Forecast - data from the Sales Budget Ending Inventory - inventory left over from the previous time period Beginning Inventory - what is left over from the previous reporting period Q1 Q2 Q3 Q4 25,000 Planned Sales (in units) 10,000 15,000 17,000 Desired Ending Inventory (in units) 750 850 1,250 1,100 Needed Inventory (in units) 10,750 15,850 18,250 26,100 Less Beginning Inventory 750 850 1,250 Units to be Produced 10,750 15,100 17,400 24,850 To meet the sales projection, how many mice do you have to produce? 0 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

Energy Management Audit And Conservation

Authors: U. P. Kumar Chaturvedula

1st Edition

6202015985, 978-6202015981

More Books

Students also viewed these Accounting questions

Question

What is the environment we are trying to create?

Answered: 1 week ago

Question

How can we visually describe our goals?

Answered: 1 week ago