Question

Tillman Cycles manufactures chainless bicycles. On March​ 31, Tillman Cycles had 210 bikes in inventory. The...

Tillman Cycles manufactures chainless bicycles. On March​ 31, Tillman Cycles had 210 bikes in inventory. The company has a policy that the ending inventory in any month must be 20 % of the following​ month's expected sales. Tillman Cycles expects to sell the following number of bikes in each of next four​ months:

LOADING...

​(Click the icon to view the​ data)

April. . . . . . . . . . . . . . . . . . . . . . . .

1,050 bikes

May. . . . . . . . . . . . . . . . . . . . . . . .

1,160 bikes

June. . . . . . . . . . . . . . . . . . . . . . . .

1,320 bikes

July. . . . . . . . . . . . . . . . . . . . . . . .

1,250 bikes

Prepare a production budget for the second​ quarter, with a column for each month and for the quarter.

Tillman Cycles

Production Budget

For the Months of April through June

April

May

June

Quarter

Unit sales

Plus:

Desired ending inventory

Total needed

Less:

Beginning inventory

Units to produce

0 0
Add a comment Improve this question Transcribed image text
✔ Recommended Answer
Answer #1

Answer Unit Sales Plus: Desired Ending Inventory Total Needed Less: Beginning Inventory Units to be produced Tillman Cycles P

Add a comment
Know the answer?
Add Answer to:
Tillman Cycles manufactures chainless bicycles. On March​ 31, Tillman Cycles had 210 bikes in inventory. The...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Trainor Cycles manufactures chainless bicycles. On March 31, Trainor Cycles had 107 bikes in inventory. The...

    Trainor Cycles manufactures chainless bicycles. On March 31, Trainor Cycles had 107 bikes in inventory. The company has a policy that the ending inventory in any month must be 10% of the following month's expected sales. Trainor Cycles expects to sell the following number of bikes in each of next four months: E: (Click the icon to view the data) Prepare a production budget for the second quarter, with a column for each month and for the quarter. i Data...

  • 59-5 (similar to) Question Help Trader Cycles maractures chainless bicycles. On March 31, Trader Cycles had...

    59-5 (similar to) Question Help Trader Cycles maractures chainless bicycles. On March 31, Trader Cycles had 300 bikes in Inventory. The company has a policy that the ending inventory in any month must be 30% of the following month's expected sales Trader Cycles expects to sell the following number of bikes in each of next four months Click the loon to view the data) Prepare a production budget for the second quarter with a column for each month and for...

  • 1 of 12 (2 complete) HW Score: 5.74%, 1.44 of 25 pts Score: 0 of 1...

    1 of 12 (2 complete) HW Score: 5.74%, 1.44 of 25 pts Score: 0 of 1 pt X 59-5 (similar to) Question Help Trapper Cycles manufactures chainless bicycles. On March 31, Trapper Cycles had 210 bikes in inventory. The company has a policy that the ending inventory in any month must be 20% of the following month's expected sales. Trapper Cycles expects to sell the following number of bikes in each of next four months: E: (Click the icon to...

  • Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for selected months...

    Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for selected months of the year are as follows: Unit Sales April 180,000 May 220,000 June 200,000 July 240,000 Company policy requires that ending inventories for each month be 25% of next month's sales. However, at the beginning of April, due to greater sales in March than anticipated, the beginning inventory of water pumps is only 21,000. Required: Prepare a production budget for the second quarter of...

  • A merchandising firm by the name of Star Wars Enterprises, had an inventory of 42,000 units on March 31, and it had accounts receivable totaling $83,500. Sales, in units, have been budgeted as follows...

    A merchandising firm by the name of Star Wars Enterprises, had an inventory of 42,000 units on March 31, and it had accounts receivable totaling $83,500. Sales, in units, have been budgeted as follows for the next four months: April 55,000 May 65,000 June 81,000 July 79,000 To be enforced in April, Star Wars board of directors has established a policy that states that the inventory at the end of each month should contain 35% of the units required for...

  • Smith Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first...

    Smith Manufacturing produces self-watering planters for use in upscale retail establishments. Sales projections for the first five months of the upcoming year show the estimated unit sales of the planters each month to be as follows: (Click the icon to view additional information.) Inventory at the start of the year was 775 planters. The desired inventory of planters at the end of each month should be equal to 25% of the following month's budgeted sales. Each planter requires three pounds...

  • Ruiz Co. provides the following sales forecast for the next four months. Sales (units) April 560...

    Ruiz Co. provides the following sales forecast for the next four months. Sales (units) April 560 May 640 June 590 July 680 The company wants to end each month with ending finished goods inventory equal to 20% of next month's forecasted sales. Finished goods inventory on April 1 is 112 units. Prepare a production budget for the months of April, May, and June. The company wants to end each month with ending finished goods inventory equal to 20% of next...

  • Rucker Company manufactures drinking glasses. One unit is a package of eight classes, which sells for...

    Rucker Company manufactures drinking glasses. One unit is a package of eight classes, which sells for $14. Rucker projects sales for April will be 1,500 pages with sales increasing by 50 packages per month for May, June, and July. On April 1, Rucker has 25 packages on hand but desires to maintain an ending inventory of 10% of the next month's sales. Prepare a sales budget and a production budget for Rucker for April, May, and June. Rucker Company manufactures...

  • Ruiz Co. provides the following sales forecast for the next four months. April May June July...

    Ruiz Co. provides the following sales forecast for the next four months. April May June July Sales (units) 700 780 730 820 The company wants to end each month with ending finished goods inventory equal to 30% of next month's forecasted sales. Finished goods inventory on April 1 is 210 units. Prepare a production budget for the months of April, May, and June.

  • Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for selected months...

    Aqua-pro Inc. produces submersible water pumps for ponds and cisterns. The unit sales for selected months of the year are as follows: Unit Sales April 180,000 May 220,000 June 200,000 July 240,000 Company policy requires that ending inventories for each month be 25% of next month's sales. However, at the beginning of April, due to greater sales in March than anticipated, the beginning inventory of water pump is only 21,000. Required: Prepare a production budget for the second quarter of...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT