Question
Tonka toys manufactures a toy truck called Big Red that they distribute to retailers. The company is now planning for the third quarter of 2020.
Tonka toys manufactures a toy truck called "Big Red" that they distribute to retailers. The company is now planning for the third quarter of 2020. In order to keep production and shipments moving smoothly, the company has the following inventory requirements:
a.The finished goods inventory on hand at the end of each month must be equal to 5,000 units plus 30 percent of the next month's sales. The finished goods inventory on June 30 is budgeted to be 17,000 units.
b.Big Red, requires three kilograms of plastic to make. The raw material inventory on hand at the end of each month must be equal to one half of the following month's production needs for raw materials. The raw materials inventory on June 30 is budgeted to be 64,500 kilograms. One kilogram of plastic can be purchased for $0.15.
c.The company maintains no work in process inventory.
d.The Big Red Truck sells for $35.00 per unit. Forecast ed unit sales for Big Red for the last nine months of 2020 is given below:
Budgeted Sales (units)
April30,000
May35,000
June39,000
July40,000
August50,000
September70,000
October35,000
November20,000
December10,000
e.Fifteen percent of Big Red Truck sales are on a cash basis whereas the remaining eighty-five percent are on credit. History has shown the following collection pattern for credit sales:
30% are collected in the month of sale
40 % are collected in the month following the sale
20 % are collected two months after the sale
5% are collected three months after the sale
The remaining 5% are bad debts.
Required:
a.Prepare production budget for Big Red for the third quarter of the year. Make sure you show each month separately as well as a total column for the third quarter.
b.Prepare raw material purchase budget for the third quarter of the year. Make sure you show each month separately as well as a total column for the third quarter.
c.Prepare schedule showing the cash collections resulting from credit sales. Make sure you show each month separately as well as a total column for the third quarter.
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