Create a level plan with a zero ending inventory for the forecast shown in the table....

Create a level plan with a zero ending inventory for the forecast shown in the table. There is no beginning inventory and regular production capacity is 300 units. Subcontracting is limited to 60 units per month and costs $10 per unit. There is a cost of $5 per month to hold a unit in inventory. What is the total plan cost (i.e. subcontracting + inventory)?

Hint: In a level production plan, production is held constant in every time period. Use regular production, subcontracting, and inventory to create the plan.

Month	Forecast	Regular	Subcontracting	Monthly Inventory Change	Ending Inventory
January	250
February	300
March	400
April	350

Solutions

Expert Solution

Below is the screenshot of the formula applied -

Below is the screenshot of the result -

keosha answered 2 hours ago

Next > < Previous

Related Solutions

Given the forecast and booked orders shown in the? table, and a beginning inventory of? 75,...

Given the forecast and booked orders shown in the? table, and a beginning inventory of? 75, what is the available to promise inventory for period? 4? The company operates with a lot size of 50. Period 1 2 3 4 Forecasted Demand 500 450 400 600 Booked Orders 520 400 325 450 Projected Ending Inventory Master Production Schedule Available to Promise

The information shown below relating to the ending inventory was taken at lower of cost or...

The information shown below relating to the ending inventory was taken at lower of cost or NRV from the records of Electronics Corp.: Per Unit Inventory Classification Quantity Cost NRV Keyboards Stock A 18 $ 96 $ 75 Stock B 23 82 66 Stock C 21 106 125 Hard drives Stock X 31 195 176 Stock Y 52 187 214 CD burners Stock D 84 90 71 Stock E 212 122 146 Required: 1-a. Determine the valuation of the above...

There are 10 units in ending inventory compute the value of the ending inventory using the...

There are 10 units in ending inventory compute the value of the ending inventory using the periodic inventory method. Compute the answer using FIFO, LIFO and the average cost methods. (round your answer to the nearest whole number) Price Cost Number Per Per Date Transaction of units unit Purchase Apr. 3 Inventory 2 10 20 8 Purchase 2 15 30 11 Purchase 3 20 60 30 Purchase 2 25 50 May 8 Purchase 3 25 75 10 Purchase 3 30...

For the following soil profile, when the water table elevation is lowered to the level shown:

For the following soil profile, when the water table elevation is lowered to the level shown:(a). What is the change in the effective stress at Point A?(b). What will be the consequence of the effective stress change?Assume that the total unit weight γ of the sand layer above the water table will decrease 5% from its saturated unit weight after lowering the water table.

Shown below in T-account format are the beginning and ending balances ($ in millions) of both inventory and accounts payable.

Shown below in T-account format are the beginning and ending balances ($ in millions) of both inventory and accounts payable. Required: 1. Use a T-account analysis to determine the amount of cash paid to suppliers of merchandise during the reporting period if cost of goods sold was $300 million. 2. Prepare a summary entry that represents the net effect of merchandise purchases during the reporting period.

In comparing the ending inventory balances of FIFO andLIFO, the ending inventory value under FIFO...

Fulbright Corp. uses the periodic inventory system. During its first year of operations, Fulbright made the following purchases (listed in chronological order of acquisition): 40 units at $100 per unit 70 units at $80 per unit 170 units at $60 per unit Sales for the year totaled 270 units, leaving 10 units on hand at the end of the year. In comparing the ending inventory balances of FIFO and LIFO, the ending inventory value under FIFO less the ending inventory balance under LIFO results in...

The following data are provided regarding an entities ending inventory year current cost of ending inventory...

The following data are provided regarding an entities ending inventory year current cost of ending inventory cumulative price level 15 250,000 100 16 342,000 120 17 383,500 130 18 375,000 125 19 406,000 140 Calculate ending inventory for each year, 2015 through 2019, inclusive, using the dollar value LIFO method as well as any reported LIFO reserve.

Complete the table to determine the cost assigned to ending inventory and cost of goods sold using specific identification.

Laker Company reported the following January purchases and sales data for its only product. Date Activities Units Acquired at Cost Units sold at Retail Jan. 1 Beginning inventory 140 units @ $ 6.00 = $ 840 Jan. 10 Sales 100 units @ $ 15 Jan. 20 Purchase 60 units @ $ 5.00 = 300 ...

Suppose the following: Beginning Inventory = 11202 Ending Inventory= 12259 Beginning Receivables = 6123 Ending Receivables...

Suppose the following: Beginning Inventory = 11202 Ending Inventory= 12259 Beginning Receivables = 6123 Ending Receivables = 6623 Beginning Payables = 8425 Ending Payables = 8827 Credit Sales = 91254 Cost of Goods Sold = 72320 Calculate the following (round final answers to 2 decimal places): Operating Cycle = days Cash Cycle = days

Suppose the following: Beginning Inventory = 11141 Ending Inventory= 12245 Beginning Receivables = 6450 Ending Receivables...

Suppose the following: Beginning Inventory = 11141 Ending Inventory= 12245 Beginning Receivables = 6450 Ending Receivables = 6825 Beginning Payables = 8304 Ending Payables = 8758 Credit Sales = 91199 Cost of Goods Sold = 73243 Calculate the following (round final answers to 2 decimal places): Operating Cycle = days Cash Cycle = days

Subjects