A sales budget is given below for one of the productsmanufactured by the Key Co.: Sales Budget in Units January 20,000February 35,000 March 60,000 April 40,000 May 30,000 June 25,000The inventory of finished goods at the end of each month must equal17% of the next monthâs sales. On December 31, the finished goodsinventory totaled 3,400 units. Each unit of product requires threespecialized electrical switches. Since the production of thesespecialized switches by Keyâs suppliers is sometimes irregular, thecompany has a policy of maintaining an ending inventory at the endof each month equal to 36% of the next monthâs production needs.This requirement had been met on January 1 of the current year.Required: Prepare a production plan for January, February, Marchand April. (Input all amounts as positive values.) January FebruaryMarch April Total needs Units to be produced Calculate the quantityof switches to be purchased each month for January, February, Marchand in total for the quarter. (Input all amounts as positivevalues.) January February March Quarter Total needs Requiredpurchases
A sales budget is given below for one of the productsmanufactured by the Key Co.: Sales Budget in Units January 20,000February 35,000 March 60,000 April 40,000 May 30,000 June 25,000The inventory of finished goods at the end of each month must equal17% of the next monthâs sales. On December 31, the finished goodsinventory totaled 3,400 units. Each unit of product requires threespecialized electrical switches. Since the production of thesespecialized switches by Keyâs suppliers is sometimes irregular, thecompany has a policy of maintaining an ending inventory at the endof each month equal to 36% of the next monthâs production needs.This requirement had been met on January 1 of the current year.Required: Prepare a production plan for January, February, Marchand April. (Input all amounts as positive values.) January FebruaryMarch April Total needs Units to be produced Calculate the quantityof switches to be purchased each month for January, February, Marchand in total for the quarter. (Input all amounts as positivevalues.) January February March Quarter Total needs Requiredpurchases
Related questions
| A sales budget is given below for one of the products manufacturedby the Key Co.: |
| Sales Budget in Units | |
| January | 14,000 |
| February | 29,000 |
| March | 54,000 |
| April | 97,000 |
| May | 24,000 |
| June | 19,000 |
The inventory of finished goods at the end of each month must equal18% of the next month%u2019s sales. This requirement had been meton January 1 of the current year. |
Each unit of product requires four specialized electrical switches.Since the production of these specialized switches by Key%u2019ssuppliers is sometimes irregular, the company has a policy ofmaintaining an ending inventory at the end of each month equal to34% of the next month%u2019s production needs. This requirement hadbeen met on January 1 of the current year. |
| Required: |
Prepare a production plan for January, February, March and in totalfor the quarter. (Input all amounts as positive values.) |
| January | February | March | Total | |
| (Click to select)Budgeted salesAdd: Desired endinginventoryDeduct: Beginning inventoryDeduct: Desired endinginventoryAdd: Beginning inventory | ||||
| (Click to select)Budgeted salesAdd: Desired endinginventoryDeduct: Beginning inventoryAdd: Beginning inventoryDeduct:Desired ending inventory | ||||
| Total needs | ||||
| (Click to select)Budgeted salesAdd: Desired endinginventoryDeduct: Desired ending inventoryDeduct: BeginninginventoryAdd: Beginning inventory | ||||
| Units to be produced | ||||
| | | | | |
