Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question #2 (40 marks) The following sales forecast was developed by the sales team at a M& M Manufacturing Company Limited for the months indicated.
Question #2 (40 marks)
The following sales forecast was developed by the sales team at a M& M Manufacturing Company Limited for the months indicated. The company produces two products Bassinets and Swings
Sales Forecast 2021
Details | Bassinets | Swings |
July | 1.500 units | 2,000 units |
August | 1,750 units | 2,250 units |
September | 1,900 units | 2,000 units |
October | 1,400 units | 1,600 units |
November | 1,700 units | 1,500 units |
December | 2,200 units | 2,300 units |
Notes:
- To make one unit of bassinet four (4) units of raw material F250 is used. One unit of F250 costs $40. Swings uses two (2) units of raw material K200 which costs $30 each.
- The company has decided that raw material stocks at the end of each month should be held equivalent to fifteen percent (15%) of the budgeted sales for the month in question.
- During the year, the company sold one unit of Bassinet for $110, while one unit of Swing was sold for $150.
- The decision was made that at the end of each month there should be in store sufficient finished goods stock to meet twenty percent (20%) of the sales for the next month.
Required:
Prepare the following budgets for the months of August to November 2021:
- Sales budget for both products (6 marks)
- Production budget for both products (10 marks)
- Direct raw materials usage budget. (5 marks)
- Direct raw material purchase budget. (15 marks)
- Briefly explain, using two examples what is meant by a limiting budget factor
(4 marks)
Step 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