Question

In: Accounting

Big toys manufacture a toy truck called “Big Red” that they distribute to retailers. The company...

Big toys manufacture 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:

  1. 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.
  2. 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.

  1. The company maintains no work in process inventory.

  1. The Big Red Truck sells for $35.00 per unit. Forecasted unit sales for Big Red for the last nine months of 2020 is given below:

Budgeted Sales (units)

April                                        30,000

May                                         35,000

June                                         39,000

July                                          40,000

August                                                50,000

September                               70,000

October                                   35,000

November                               20,000

December                                10,000

  1. 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:

  1. Prepare a 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.

  1. Prepare a 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.

  1. Prepare a 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.

Solutions

Expert Solution

Thank you for your patience. Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!
Big toys
Answer C
Sales Budget April May June July August September Qtr. 3 Note
Sales (units)         30,000.00         35,000.00         39,000.00         40,000.00         50,000.00         70,000.00         160,000.00 A
Sell Price                 35.00                 35.00                 35.00                 35.00                 35.00                 35.00 B
Sales Budget 1,050,000.00 1,225,000.00 1,365,000.00 1,400,000.00 1,750,000.00 2,450,000.00      5,600,000.00 C=A*B
Cash sale is 15%       210,000.00       262,500.00       367,500.00         840,000.00 D=C*15%
Credit sale is 85%       892,500.00    1,041,250.00    1,160,250.00    1,190,000.00    1,487,500.00    2,082,500.00      4,760,000.00 E=C*85%
Schedule of Cash Receipts July August September Qtr. 3 Note
15% cash sale       210,000.00       262,500.00       367,500.00         840,000.00 See D
30% of credit sales collected in same month       357,000.00       446,250.00       624,750.00      1,428,000.00 F=E*30%
40% of credit sales collected in next month       476,000.00       595,000.00      1,071,000.00 G= 40% of E of previous month.
20% of credit sales collected in second month       238,000.00         238,000.00 H= 20% of E of previous to previous month.
Collection of April credit Sales -5%         44,625.00           44,625.00
Collection of May credit Sales -20%, 5%       208,250.00         52,062.50         260,312.50
Collection of June credit Sales -40%, 20%, 5%       464,100.00       232,050.00         58,012.50         754,162.50
Expected cash collections 1,283,975.00 1,468,862.50 1,883,262.50      4,636,100.00
Answer A
Production Budget July August September Qtr. 3 October November December Note
Sales (units)         40,000.00         50,000.00         70,000.00         160,000.00             35,000.00           20,000.00           10,000.00 See C
Add: Desired Ending Inventory         20,000.00         26,000.00         15,500.00           15,500.00             11,000.00             8,000.00 I=30% of C of next month + 5,000 units.
Total needed         60,000.00         76,000.00         85,500.00         175,500.00            46,000.00          28,000.00
Less: Expected Beginning Inventory         17,000.00         20,000.00         26,000.00           17,000.00             15,500.00           11,000.00 J=30% of C of same month + 5,000 units.
Production Budget         43,000.00         56,000.00         59,500.00         158,500.00            30,500.00          17,000.00 K
Answer B
Direct Material Purchase Budget July August September Qtr. 3 October Note
Production Budget         43,000.00         56,000.00         59,500.00         158,500.00             30,500.00 See K
Material required per unit                   3.00                   3.00                   3.00                       3.00 L
Material needed for production       129,000.00       168,000.00       178,500.00         475,500.00            91,500.00 M=K*L
Add: Desired Ending Inventory         84,000.00         89,250.00         45,750.00            45,750.00 N=50% of M of next month
Total needed       213,000.00       257,250.00       224,250.00         521,250.00
Less: Expected Beginning Inventory         64,500.00         84,000.00         89,250.00            64,500.00 O=50% of M of same month.
Direct Material Purchase Budget (Kg)       148,500.00       173,250.00       135,000.00         456,750.00 P
Cost per Kg                   0.15                   0.15                   0.15 Q
Direct Material Purchase Budget ($)         22,275.00         25,987.50         20,250.00           68,512.50 R=P*Q

Related Solutions

Tonka toys manufactures a toy truck called “Big Red” that they distribute to retailers. The company...
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: 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....
Question 1: (24 marks) Tonka toys manufactures a toy truck called “Big Red” that they distribute...
Question 1: 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: 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...
Sam's Dog toys sells a Red toy and a Blue toy. The contribution margin for the Red toy is $2 and for the Blue toy is $3
Sam's Dog toys sells a Red toy and a Blue toy. The contribution margin for the Red toy is $2 and for the Blue toy is $3. The expected sales mix is 80% for Red toy and 20% for Blue toy. The total fixed costs amount to $2,112 and the company desires to earn a profit of $264. What is the sale volume in units necessary to reach the desired profit?1,056 total units960 total units120 total units1,080 total units
The Tiny Toy Company makes three types of new toys: the tiny tank, the tiny truck,...
The Tiny Toy Company makes three types of new toys: the tiny tank, the tiny truck, and the tiny turtle. Plastic used in one unit of each is 1.5, 2.0 and 1.0 pounds, respectively. Rubber for one unit of each toy is 0.5, 0.5, and 1.0 pounds, respectively. Also, each tank uses 0.3 pounds of metal and the truck uses 0.6 pounds of metal during production. The average weekly availability for plastic is 16,000 pounds, 9,000 pounds of metal, and...
Dawson Toys, Ltd., produces a toy called the Maze. The company has recently established a standard...
Dawson Toys, Ltd., produces a toy called the Maze. The company has recently established a standard cost system to help control costs and has established the following standards for the Maze toy: Direct materials: 7 microns per toy at $0.35 per micron Direct labor: 1.3 hours per toy at $6.70 per hour During July, the company produced 5,300 Maze toys. Production data for the month on the toy follow: Direct materials: 76,000 microns were purchased at a cost of $0.34...
Townsend Toys, Ltd., produces a toy called the Puzzler. The company has recently established a standard...
Townsend Toys, Ltd., produces a toy called the Puzzler. The company has recently established a standard cost system to help control costs and has established the following standards for the Puzzler toy: Direct materials: 6 microns per toy at $0.33 per micron Direct labor: 1.3 hours per toy at $7.30 per hour During July, the company produced 5,300 Puzzler toys. The toy's production data for the month are as follows: Direct materials: 71,000 microns were purchased at a cost of...
Dawson Toys, Ltd., produces a toy called the Maze. The company has recently established a standard...
Dawson Toys, Ltd., produces a toy called the Maze. The company has recently established a standard cost system to help control costs and has established the following standards for the Maze toy: Direct materials: 7 microns per toy at $0.34 per micron Direct labor: 1.2 hours per toy at $7.40 per hour During July, the company produced 4,800 Maze toys. The toy's production data for the month are as follows: Direct materials: 79,000 microns were purchased at a cost of...
Dawson Toys, Ltd., produces a toy called the Maze. The company has recently established a standard...
Dawson Toys, Ltd., produces a toy called the Maze. The company has recently established a standard cost system to help control costs and has established the following standards for the Maze toy: Direct materials: 7 microns per toy at $0.31 per micron Direct labor: 1.2 hours per toy at $7.20 per hour During July, the company produced 4,900 Maze toys. The toy's production data for the month are as follows: Direct materials: 76,000 microns were purchased at a cost of...
Dawson Toys, Ltd., produces a toy called the Maze. The company has recently created a standard...
Dawson Toys, Ltd., produces a toy called the Maze. The company has recently created a standard cost system to help control costs and has established the following standards for the Maze toy: During July, the company produced 3,000 Maze toys. The toy’s production data for the month are as follows: Direct materials: 25,000 microns were purchased at a cost of $1.48 per micron. 5,000 of these microns were still in inventory at the end of the month. Direct labor: 4,000...
Dawson Toys, Ltd., produces a toy called the Maze. The company has recently established a standard...
Dawson Toys, Ltd., produces a toy called the Maze. The company has recently established a standard cost system to help control costs and has established the following standards for the Maze toy: Direct materials: 7 microns per toy at $0.32 per micron Direct labor: 1.4 hours per toy at $7.30 per hour During July, the company produced 5,300 Maze toys. The toy's production data for the month are as follows: Direct materials: 71,000 microns were purchased at a cost of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT