Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Unicorn Pool Toys manufactures and distributes a number of summer and outdoor pool products to retailers across North America. One of their products, the Flamingo
Unicorn Pool Toys manufactures and distributes a number of summer and outdoor pool products to retailers across North America. One of their products, the Flamingo Island floatie, is a large 4-6 person raft. It requires three (3) kilograms of plastic per unit to manufacture. It is currently January 2021 and the company is planning their raw materials needs for the third quarter, which takes place during the busy summer months of July, August and September. Sales of their products are highest in the summer months, so it is very important that they have enough materials on hand. On order to keep production and shipments moving smoothly and not lose any sales, the company has implemented the following inventory requirements: a) Finished goods inventory on hand at the end of each month must be equal to 9,000 units plus 25% of the next month's sales. The finished goods inventory on hand at June 30th is budgeted to be 24,500 units. b) Raw materials inventory on hand at the end of each month must be equal to 35% of the following month's production needs for raw materials. The raw materials inventory on hand at June 30th for plastic material is budgeted to be 135,000 kilograms. c) The company maintains no work in process inventories. A sales budget for the Flamingo Island Floatie for the last six (6) months of the year is as follows: Month Budgeted Sales in Units July 95,000 August 80,000 September 75,000 October 60,000 November 25,000 December 10,000 REQUIRED: a) Prepare a production budget for the Flamingo Island floatie for the months of July, August, September and October. (8 marks) b) Prepare a direct materials purchases budget showing the quantity of plastic material to be purchased for the months of July, August and September, and for the quarter in total. (12 marks) c) If the plastic material costs $2.50 per kg, what will be the total materials cost for the months of July, August and September, and for the third quarter? (4 marks) NOTE re. ROUNDING: Round any calculations to ZERO decimal places
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