Question

In: Finance

Mischief Company had been experimenting with various sales and operations plans. As the firm started to...

Mischief Company had been experimenting with various sales and operations plans. As the firm started to lay out plans for next year, management decided to use a six-month planning horizon to reduce computation cost. The firm’s basic data were: Employment level for this December = 20 people. Demand forecasts for January to June of next year are 200, 240, 220, 300, 250, and 240 units respectively. Inventory level planned for the end of this December = 0. Back-orders aren’t allowed in the plan. Desired April ending inventory = 0. Regular time per month = $2,000 per worker-month. Production = 12 units/person/month. Overtime premium = 50 percent of regular time. Overtime limit = 25 percent of regular time per person per month. Inventory carrying cost = $150/month/unit (on the average per month). Hiring (or firing) cost = $2,000 per person.

to compare the cost of a fixed employment production plan (i.e., 20 people) that uses overtime to meet the demand to a level production plan that uses no overtime to meet production. 

Solutions

Expert Solution

Please refer to the calculaction below comparing total cost in fixed employment production plan in comparison to Total cost in plan that uses no overtime (new hire or fire).

Conclusion:

Total cost in fixed employment plan = USD 318500

Total cost in No overtime production plan = USD 348750.

Hence, Fixed empoyment plan (with overtime when needed) to be noted.

Please note: Inventory balance at the end of april to be taken as 0. Hence accordingly, the production units oid adjusted in below solution.


Related Solutions

Suppose that you are the CEO of TrinketsNThings. Your sales operations manager has been experimenting with...
Suppose that you are the CEO of TrinketsNThings. Your sales operations manager has been experimenting with the price of a Trinket [x], in order to see how many Trinkets customers are willing to purchase in a week [y]. She gives you the following dataset: Price of Trinket $3 $4 $5 $6 # of Trinkets Purchased (thousands) 19 15 12 8 *Calculate Cov(Price , # Purchased) *Calculate Sx2 *What is the linear relationship between the price and quantity demanded of Trinkets?...
Tausi Corporation, a company located in Tacoma, WA, started operations in September and had the following sales.
  Tausi Corporation, a company located in Tacoma, WA, started operations in September and had the following sales.   SEP OCT NOV DEC JAN FEB Total Sales $400,000 $520,000 $660,000 $900,000 $720,000 $700,000 30% of all sales are cash sales. The rest are credit sales. Credit sales are collected as follows: 20% in the month of sale, 70% in the month following sale, and 10% in the second month following sale. There are no bad debts REQUIREMENTS: (Note: As long...
The POL Company had started its operations in 2016. The balance sheet for December 31, 2016,...
The POL Company had started its operations in 2016. The balance sheet for December 31, 2016, showed the following accounts balances (there were no other accounts listed): Accounts receivables 45 Unearned revenue 40 Accumulated depreciation 10 Common stock 500 Retained earnings 57 Property plant and equipment (gross) 200 Inventory 75 Accounts payable 40 Cash 309 Prepaid rent ______ During 2017 the following transactions occurred: 1. POL purchased $375 worth of inventory on account. 2.Payments on Accounts payable were $365. 3.Cash...
A company had the following purchases and sales during its first year of operations: Purchases Sales...
A company had the following purchases and sales during its first year of operations: Purchases Sales January: 10 units at $120 6 units February: 20 units at $125 5 units May: 15 units at $130 9 units September: 12 units at $135 8 units November: 10 units at $140 13 units On December 31, there were 26 units remaining in ending inventory. Using the Perpetual FIFO inventory valuation method, what is the cost of the ending inventory? (Assume all sales...
A company had the following purchases and sales during its first year of operations: Purchases Sales...
A company had the following purchases and sales during its first year of operations: Purchases Sales January: 22 units at $180 14 units February: 32 units at $185 12 units May: 27 units at $190 16 units September: 24 units at $195 15 units November: 22 units at $200 28 units On December 31, there were 42 units remaining in ending inventory. Using the Perpetual LIFO inventory valuation method, what is the cost of the ending inventory? (Assume all sales...
A company had the following purchases and sales during its first year of operations: Purchases Sales...
A company had the following purchases and sales during its first year of operations: Purchases Sales January: 11 units at $135 7 units February: 21 units at $140 5 units May: 16 units at $145 9 units September: 13 units at $150 8 units November: 11 units at $155 14 units On December 31, there were 29 units remaining in ending inventory. Using the Perpetual LIFO inventory valuation method, what is the cost of the ending inventory? (Assume all sales...
Smith Company started business on September 1. Smith had credit sales of $200,000 in September and...
Smith Company started business on September 1. Smith had credit sales of $200,000 in September and $300,000 in October. The pattern for collection of cash from customers is expected to be 40% in the month of sale (subject to a 2% cash discount), 50% in the month following the month of sale, and 7% in the second month following the month of sale, with 3% uncollectible. How much cash did Smith Company receive from customers on account during October?.
Smith Company started business on September 1. Smith had credit sales of $200,000 in September and...
Smith Company started business on September 1. Smith had credit sales of $200,000 in September and $300,000 in October. The pattern for collection of cash from customers is expected to be 40% in the month of sale (subject to a 2% cash discount), 50% in the month following the month of sale, and 7% in the second month following the month of sale, with 3% uncollectible. How much cash did Smith Company receive from customers on account during October?
Benjamin Company had the following results of operations for the past year: Sales (19,400 units at...
Benjamin Company had the following results of operations for the past year: Sales (19,400 units at $8) $ 155,200 Direct materials and direct labor $ 97,000 Overhead (20% variable) 19,400 Selling and administrative expenses (all fixed) 27,160 (143,560 ) Operating income $ 11,640 A foreign company (whose sales will not affect Benjamin’s market) offers to buy 4,850 units at $6.40 per unit. In addition to variable manufacturing costs, selling these units would increase fixed overhead by $490 and selling and...
Markson Company had the following results of operations for the past year: Sales (8,000 units at...
Markson Company had the following results of operations for the past year: Sales (8,000 units at $20.20) $ 161,600 Variable manufacturing costs $ 86,800 Fixed manufacturing costs 15,200 Variable selling and administrative expenses 12,800 Fixed selling and administrative expenses 20,200 (135,000 ) Operating income $ 26,600 A foreign company whose sales will not affect Markson's market offers to buy 2,000 units at $14.30 per unit. In addition to variable manufacturing costs, selling these units would increase fixed overhead by $1,620...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT