Question

A sales budget is given below for one of the products manufactured by the OMI Co.:...

A sales budget is given below for one of the products manufactured by the OMI Co.:
January 25,000 units
February 40,000 units
March 65,000 units
April 45,000 units
May 35,000 units
June 30,000 units
The inventory of finished goods at the end of each month must equal 20% of the next month's sales.
However, on December 31 the finished goods inventory totaled only 4,000 units.
Each unit of product requires three pounds of specialized material.
The requires an ending inventory at the end of each month equal to 30% of the next month's production needs.
This requirement had been met on January 1 of the current year.
   Required:   Show your work!!
a. Prepare a budget showing the required production each month for January, February, March, and April.
b. Prepare a budget showing the quantity of switches to be purchased each month for January, February, and March.

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A sales budget is given below for one of the products manufactured by the Key Co.:...
A sales budget is given below for one of the products manufactured by the Key Co.: Sales Budget in Units January 20,000 February 35,000 March 60,000 April 40,000 May 30,000 June 25,000 The inventory of finished goods at the end of each month must equal 17% of the next month’s sales. On December 31, the finished goods inventory totaled 3,400 units. Each unit of product requires three specialized electrical switches. Since the production of these specialized switches by Key’s suppliers...
The sales budget is provided below for the product of Company ABC. Jan 30,000 units Feb...
The sales budget is provided below for the product of Company ABC. Jan 30,000 units Feb 20,000 units Mar 10,000 units Apr 20,000 units May 30,000 units Finished goods at the end of each month must be 10% of the next month’s budgeted sales. On Dec 31 of the last year, the finished goods totaled 2,000 units. The selling price is $1 per unit. 80% of the credit sales are collected in the month of sale, 15% in the month...
Use the following information for the Exercises below. Ruiz Co. provides the following sales forecast for...
Use the following information for the Exercises below. Ruiz Co. provides the following sales forecast for the next four months:     April May June July Sales (units) 610 690 640 730 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 122 units. Assume July's budgeted production is 640 units. In addition, each finished unit requires five pounds (lbs.) of raw materials and...
Required information Use the following information for the Exercises below. Ruiz Co. provides the following sales...
Required information Use the following information for the Exercises below. Ruiz Co. provides the following sales forecast for the next four months:     April May June July Sales (units) 650 730 680 770 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 130 units. Assume July's budgeted production is 680 units. In addition, each finished unit requires six pounds (lbs.) of raw...
1. Ruiz Co. provides the following sales forecast for the next four months. April May June...
1. Ruiz Co. provides the following sales forecast for the next four months. April May June July Sales (units) 640 720 670 760 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 128 units. Prepare a production budget for the months of April, May, and June. RUIZ CO. Production Budget For April, May, and June April May June Next month's budgeted sales...
oshua Hill, Coronado & Hill Fabricators' production manager, has just received the company's sales budget for...
oshua Hill, Coronado & Hill Fabricators' production manager, has just received the company's sales budget for the first quarter. January February March April May June 5,000 9,750 8,750 7,250 23,000 20,000 Company policy requires an ending finished goods inventory each month that will meet 5% of the following month's sales volume. Joshua plans to have 1,400 finished bricks at a cost of $12,250 in inventory at the beginning of the year. Prepare Coronado & Hill's production budget for the first...
33. Yamaguchi Swimwear has deve,oped the following sales budget, in units: January February March April May...
33. Yamaguchi Swimwear has deve,oped the following sales budget, in units: January February March April May 155,000 185,000 225,000 240,000 205,000 Beginning Inventory in January is 35,000 units. The company policy is to have 40% of the next month's inventory on hand at the end of the month. Required: Prepare a purchasing budget for the months of January - April. Do not include May.
Ramos Co. provides the following sales forecast and production budget for the next four months. April...
Ramos Co. provides the following sales forecast and production budget for the next four months. April May June July Sales (units) 530 610 560 630 Budgeted production (units) 470 600 570 570 The company plans for finished goods inventory of 150 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 30% of next month’s production needs. Beginning direct...
Problem 9-4 Karam Inc. has compiled the following data in order to put together their first...
Problem 9-4 Karam Inc. has compiled the following data in order to put together their first quarter operating budget for 2011: January February March April Sales (units) 35,000 31,000 38,000 29,000 Each unit requires three hours of direct labor. Additional information: Karam sells each unit for $95. Company policy is to have 30 percent of next month's sales (in units) in ending finished goods inventory. Company policy is to have 40 percent of next month's production needs in ending raw...
Kovarik Company has the following sales forecast for the next quarter: April, 4,000 units; May, 4,800...
Kovarik Company has the following sales forecast for the next quarter: April, 4,000 units; May, 4,800 units; June, 5,600 units. Sales totaled 3,200 units in March. The March ending finished goods inventory was 1,000 units. End-of-month finished goods inventory levels are planned to be equal to 30 percent of the next month's planned sales. Calculate the number of units of inventory Kovarik needs to purchase for April?