Question 4 A Bookmark this page Homework due Sep 14, 2021 18:00 +03 Consider the following...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 4 A Bookmark this page Homework due Sep 14, 2021 18:00 +03 Consider the following aggregate production planning problem for earphones. The company manufactures four types of earphones, and has the following demand forecast for the next six months: Month Forecast Model A Model B Model C Model D 1 120 100 100 200 .2 200 80 60 100 3 400 140 200 200 4. 200 160 200 400 80 80 160 100 180 100 80 70 Models A and B each require one hour of production time per unit to produce. Models C and D are more complex products and each requires two hours of production time per unit. The inventory holding costs are $5 per unit per month for Model A, $5 per unit per month for Model B, $10 per unit per month for Model C, and $20 per unit per month for Model D. The regular workforce consists of 6 associates. Each associate works 160 hours per month on regular time and is paid $20 per hour, for a total of $3200 per month. Each associate can also work overtime up to a maximum of 32 brours per month; the overtime pay is $30 per hour. Each associate is completely cross-trained and can work on any of the product models. The starting inventory for each model is zero. The company wants the inventory for each model at the end of the planning horizon (month 6) to be 100 units for each model. Notes: In each month; eåch associate will be paid for the entire month (160 hours), regardless of whether or not they are fully utilized. For instance, if the production plan requires only 150 hours of work for each associate, then each associate is still paid for the entire 160 hours, and will be assigned to some non-production activity for the unscheduled time. The intent of this question is to have you build and solve an optimization problem so as to find the least cost production plan. The following questions will provide a guide for one way to build this model. Problem IlII.4.a O points possible (ungraded) Which of the following is/åre the decision variables? This question is just a checkpoint to help you formulate the model. There are many ways one could formulate this model and they can be correct as well. The one we provide considers all the three as the decision variables V Amount to produce of each model in each month, call it x(), t) V Amount of inventory at end of each month for each model, call it y().t) V Amount of overtime, in total, to use in month t, call it z(t) Submit You have used 1 of 3 attempts Save Problem III.4.b 3.0/3.0 points (graded) Which of the following is/are the categóries of constraints for this model (conceptually)? Choose all that are applicable Problem III.4.d 0.0/3.0 points (graded) Determine the optimal production plan and answer the following questions based on it. What is the total regular time cost? What is the total overtime cost? What is the total inventory holding cost? Submit You have used o of 3 attempts Save Problem III.4.e 0.0/6.0 points (graded) What is the overtime plan? Le. how many hours of overtime are reguired in the following months? Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Submit You have used o of 3 attempts Save The following questions are a series of sensitivity questions, which are to be answered independently of each other. Problem III,4.f 0.0/20 points (igraded) Suppose that you can hire a temporary 7th associate to work in months 2, 3, 4. This associate would be paid the same as- the current associates. In addition you would incur a one time cost of $2500 to recruit, train, and then lay off this temporary associate. Determine the total cost savings from this solution compared to the previous optimal (considering the one time cost of $2500). The following questions are a series of sensitivity questions, which are to be answered independently of each other. Problem III.4.f 0.0/2.0 points (graded) Suppose that you can hire a temporary 7th associate to work in months 2, 3, 4. This associate would be paid the same as the current associates. In addition you would incur a one time cost of $2500 to recruit, train; and then lay off this temporary associate. Determine the total cost savings from this solution compared to the previous optimal (considering the one time cost of $2500). Submit You have used 0 of 3 attempts Save Problem III.4.g 0.0/2.0 points (graded) Suppose you are worried about excessive reliance on overtime. What is the cost impact from reducing the maximum number of overtime hours from 32 to 24 hours per month? Determine the new total cost. Submit You have used O of 3 attempts Save Problem III.4.h 0.0/2.0 points (graded) Suppose the marketing department is considering a campaign that would boost the demand forecast for Model D from 400 tỏ 500 units in month 4. The gross margin for Model D is $75, so this campaign could increase the revenue by $7500. By how much will the production costs increase? Include the cost of holding inventory. Does the increase in revenue cover the increase in cost? O Yes ONo Save Submit You have used O of 3 attempts Earphones (External resource) Aggregate Production Planning: Earphones You can use this MATLAH biock to calculate your answers Question 4 A Bookmark this page Homework due Sep 14, 2021 18:00 +03 Consider the following aggregate production planning problem for earphones. The company manufactures four types of earphones, and has the following demand forecast for the next six months: Month Forecast Model A Model B Model C Model D 1 120 100 100 200 .2 200 80 60 100 3 400 140 200 200 4. 200 160 200 400 80 80 160 100 180 100 80 70 Models A and B each require one hour of production time per unit to produce. Models C and D are more complex products and each requires two hours of production time per unit. The inventory holding costs are $5 per unit per month for Model A, $5 per unit per month for Model B, $10 per unit per month for Model C, and $20 per unit per month for Model D. The regular workforce consists of 6 associates. Each associate works 160 hours per month on regular time and is paid $20 per hour, for a total of $3200 per month. Each associate can also work overtime up to a maximum of 32 brours per month; the overtime pay is $30 per hour. Each associate is completely cross-trained and can work on any of the product models. The starting inventory for each model is zero. The company wants the inventory for each model at the end of the planning horizon (month 6) to be 100 units for each model. Notes: In each month; eåch associate will be paid for the entire month (160 hours), regardless of whether or not they are fully utilized. For instance, if the production plan requires only 150 hours of work for each associate, then each associate is still paid for the entire 160 hours, and will be assigned to some non-production activity for the unscheduled time. The intent of this question is to have you build and solve an optimization problem so as to find the least cost production plan. The following questions will provide a guide for one way to build this model. Problem IlII.4.a O points possible (ungraded) Which of the following is/åre the decision variables? This question is just a checkpoint to help you formulate the model. There are many ways one could formulate this model and they can be correct as well. The one we provide considers all the three as the decision variables V Amount to produce of each model in each month, call it x(), t) V Amount of inventory at end of each month for each model, call it y().t) V Amount of overtime, in total, to use in month t, call it z(t) Submit You have used 1 of 3 attempts Save Problem III.4.b 3.0/3.0 points (graded) Which of the following is/are the categóries of constraints for this model (conceptually)? Choose all that are applicable Problem III.4.d 0.0/3.0 points (graded) Determine the optimal production plan and answer the following questions based on it. What is the total regular time cost? What is the total overtime cost? What is the total inventory holding cost? Submit You have used o of 3 attempts Save Problem III.4.e 0.0/6.0 points (graded) What is the overtime plan? Le. how many hours of overtime are reguired in the following months? Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Submit You have used o of 3 attempts Save The following questions are a series of sensitivity questions, which are to be answered independently of each other. Problem III,4.f 0.0/20 points (igraded) Suppose that you can hire a temporary 7th associate to work in months 2, 3, 4. This associate would be paid the same as- the current associates. In addition you would incur a one time cost of $2500 to recruit, train, and then lay off this temporary associate. Determine the total cost savings from this solution compared to the previous optimal (considering the one time cost of $2500). The following questions are a series of sensitivity questions, which are to be answered independently of each other. Problem III.4.f 0.0/2.0 points (graded) Suppose that you can hire a temporary 7th associate to work in months 2, 3, 4. This associate would be paid the same as the current associates. In addition you would incur a one time cost of $2500 to recruit, train; and then lay off this temporary associate. Determine the total cost savings from this solution compared to the previous optimal (considering the one time cost of $2500). Submit You have used 0 of 3 attempts Save Problem III.4.g 0.0/2.0 points (graded) Suppose you are worried about excessive reliance on overtime. What is the cost impact from reducing the maximum number of overtime hours from 32 to 24 hours per month? Determine the new total cost. Submit You have used O of 3 attempts Save Problem III.4.h 0.0/2.0 points (graded) Suppose the marketing department is considering a campaign that would boost the demand forecast for Model D from 400 tỏ 500 units in month 4. The gross margin for Model D is $75, so this campaign could increase the revenue by $7500. By how much will the production costs increase? Include the cost of holding inventory. Does the increase in revenue cover the increase in cost? O Yes ONo Save Submit You have used O of 3 attempts Earphones (External resource) Aggregate Production Planning: Earphones You can use this MATLAH biock to calculate your answers
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
The Hawley Lighting Company manufactures four types of lamps at its factory including table lamps, floor lamps, ceiling lamps, and pendant lamps. Table 1 presents the average material costs for each...
-
The Hawley Lighting Company manufactures four types of lamps at its factory including table lamps, floor lamps, ceiling lamps, and pendant lamps. Table 1 presents the average material costs for each...
-
Consider the following Aggregate Planning problem. a. What is the production rate per worker per day? b. What is the production rate per worker per Month? c. What is the wage rate per worker per...
-
Use a calculator to approximate the value. Round your answer to two decimal places. arccos(0.051)
-
Complete the following table by indicating whether the transactions or economic events would increase, decrease, or have no effect on the financial ratios listed. Consider each item independently....
-
London Falls Inc. had a beginning balance of $15,000 in its Accounts Receivable account. The ending balance of Accounts Receivable was $8,500. During the period, London Falls collects $65,000 of its...
-
What is the formula for calculating the factory overhead applied rate?
-
On January 8, the end of the first weekly pay period of the year, Regis Company's payroll register showed that its employees earned $22,760 of office salaries and $65,840 of sales salaries....
-
Shelly's assets include money in checking and savings accounts, investments in stocks and mutual funds, and personal property, including furniture, appliances, an automobile, a coin collection, and...
-
SuperCity is a large retailer of electronics and appliances. The store sells three different models of TVs that are ordered from different manufacturers. The demands, costs, and storage requirements...
-
Refer to Exhibit 9. For France, the opportunity cost of producing one unit of Brie is a. 2 b. 1/10 c. % d. 1/3 . 10 unitis) of Sungria. Refer to Exhibit 9. For Spain, the opportunity cost of...
-
Your friend deposits $10,000 in an account today in hope that it grows to $14,250 in 5 years.What annual compounded rate would she need to earn? (B) Suppose your friend then realizes she can expect...
-
Draw the control flow graph for the following piece of code: Function fn_delete_element (int value, int array_size, int array[]) 1 int i; location array_size + 1; 2 for i=1 to array_size 3 if...
-
You own a bond of the XYZ Corporation. Yesterday after the market closed the company CEO revealed the SEC was investigating the company for accounting irregularities. The perceived credit quality of...
-
The auctions for the next set of t-bills (zero coupon government bonds) are due in 10 days. The bond has a life of 180 days and face value of 100. One of your friends has also suggested an investment...
-
Bex Limited just paid a dividend of $0.50, and dividends are expected to grow at a constant rate of 6.5% per year. The ordinary shares currently sell for $18.00 a share, but to sell a new issue,...
-
You have decided that you want to be a millionaire when you retire in 45 years. a. If you can earn an annual return of 11.36 percent, how much do you have to invest today? (Do not round intermediate...
-
a. What is the cost of borrowing if Amarjit borrows $28 500 and repays it over a four-year period? b. How many shares of each stock would he get if he used the $28 500 and invested equally in all...
-
The Petaluma Daily Times Corporation (CDT) publishes a daily newspaper. A 52 -week subscription sells for \(\$ 260\). Assume that CDT sells 100 subscriptions on January 1. None of the subscriptions...
-
Clifford Company has just billed a customer for \(\$ 1,100\), an amount that includes an eight percent excise tax and a two percent state sales tax. a. What amount of revenue is recorded? b. Prepare...
-
For each of the following situations, indicate the amount shown as a liability on the balance sheet of Cooper, Inc., at December 31: a. Cooper has accounts payable of \(\$ 120,000\) for merchandise...
Study smarter with the SolutionInn App