DFG manufactures two products from different combinations of the same resources. Unit selling prices and unit...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
DFG manufactures two products from different combinations of the same resources. Unit selling prices and unit cost details for each product are as follows: Product Selling price D G S/unit S/unit 115 120 Direct material A ($5 per kg) 20 Direct material B ($3 per kg) 12 Skilled labour ($7 per hour) 28 Variable overhead ($2 per machine hour) Fixed overhead* NANNO 14 28 228 10 24 21 18 38 Profit 13 11 *Fixed overhead is absorbed using an absorption rate per machine hour. It is an unavoidable central overhead cost that is not affected by the mix or volume of products produced. The maximum weekly demand for products D and G is 400 units and 450 units respectively and this is the normal weekly production volume achieved by DFG. Product D is sold to an important customer who has a contract to purchase a minimum of 300 units per month. There are significant financial penalties if they fail to deliver this quantity. Required Part 1: (Do Not Use Solver) 1. Management is reviewing production plans for the next four weeks and has determined that Material A will be in short supply. There will only be 1,000 kg Material A available each week during this period. Prepare calculations to show the optimal weekly production plan for the next four weeks. (You can assume that DFG has no inventories of these products.) 2. A new supplier has offered to supply 200 kg of Material A per week. What is the maximum price per kg that DFG should pay for this material? Justify your answer with calculations. Required Part 2: (Do Not Use Solver) 1. After double checking material and labour availability Management has discovered that it is Skilled labour that will be in short supply. There will be no shortage of Material A, but there will only be 2,500 hours of Skilled labour available each week during this period. Prepare calculations to show the optimal weekly production plan for the next four weeks. 2. The production manager wants to authorize the Skilled Employees to work 100 hours overtime. These employees would be paid $10.50 for overtime rather than $7.00. Should the overtime be approved? Justify your answer with calculations. Required Part 3: After doing some further research Management discover that there will be a shortage of other resources during the next four weeks. The resources that are expected to be available are as follows: Direct material A Direct material B Skilled labour Machine time 1,800kg 3,500kg 2,500 hours 6,500 machine hours Use Solver to calculate the optimal weekly production plan for the next four weeks, given the above constraints. Print out the answer report and the sensitivity report, then answer the following questions: a) How many units of product D and product G should be produced to maximize contribution? b) Which constraints are binding? c) If the purchasing manager can access an additional 200 kg of material B at the current price what will be the effect on the contribution margin? d) If the purchasing manager can access an additional 200 kg of material B at $5 per kg what will be the effect on the contribution margin? e) The production manager said that he could increase this skilled labour hours available by 300 if management would authorize over time. Why is this not a good idea? f) If the purchasing manager can access an additional 200 kg of material A and 200 kg of material B what will be the effect on the contribution margin? DFG manufactures two products from different combinations of the same resources. Unit selling prices and unit cost details for each product are as follows: Product Selling price D G S/unit S/unit 115 120 Direct material A ($5 per kg) 20 Direct material B ($3 per kg) 12 Skilled labour ($7 per hour) 28 Variable overhead ($2 per machine hour) Fixed overhead* NANNO 14 28 228 10 24 21 18 38 Profit 13 11 *Fixed overhead is absorbed using an absorption rate per machine hour. It is an unavoidable central overhead cost that is not affected by the mix or volume of products produced. The maximum weekly demand for products D and G is 400 units and 450 units respectively and this is the normal weekly production volume achieved by DFG. Product D is sold to an important customer who has a contract to purchase a minimum of 300 units per month. There are significant financial penalties if they fail to deliver this quantity. Required Part 1: (Do Not Use Solver) 1. Management is reviewing production plans for the next four weeks and has determined that Material A will be in short supply. There will only be 1,000 kg Material A available each week during this period. Prepare calculations to show the optimal weekly production plan for the next four weeks. (You can assume that DFG has no inventories of these products.) 2. A new supplier has offered to supply 200 kg of Material A per week. What is the maximum price per kg that DFG should pay for this material? Justify your answer with calculations. Required Part 2: (Do Not Use Solver) 1. After double checking material and labour availability Management has discovered that it is Skilled labour that will be in short supply. There will be no shortage of Material A, but there will only be 2,500 hours of Skilled labour available each week during this period. Prepare calculations to show the optimal weekly production plan for the next four weeks. 2. The production manager wants to authorize the Skilled Employees to work 100 hours overtime. These employees would be paid $10.50 for overtime rather than $7.00. Should the overtime be approved? Justify your answer with calculations. Required Part 3: After doing some further research Management discover that there will be a shortage of other resources during the next four weeks. The resources that are expected to be available are as follows: Direct material A Direct material B Skilled labour Machine time 1,800kg 3,500kg 2,500 hours 6,500 machine hours Use Solver to calculate the optimal weekly production plan for the next four weeks, given the above constraints. Print out the answer report and the sensitivity report, then answer the following questions: a) How many units of product D and product G should be produced to maximize contribution? b) Which constraints are binding? c) If the purchasing manager can access an additional 200 kg of material B at the current price what will be the effect on the contribution margin? d) If the purchasing manager can access an additional 200 kg of material B at $5 per kg what will be the effect on the contribution margin? e) The production manager said that he could increase this skilled labour hours available by 300 if management would authorize over time. Why is this not a good idea? f) If the purchasing manager can access an additional 200 kg of material A and 200 kg of material B what will be the effect on the contribution margin?
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
b . Assuming a linear relationship, use the least - squares method to compute the regression coefficients and . enter your response here and enter your response here ( Round to two decimal places as...
-
THS produces two products from different combinations of the same resource. Details of the products are shown below: THS is preparing the production plan for next month. The maximum resource...
-
What is the atomic weight of a hypothetical element consisting of two isotopes, one with mass= 64.23 amu (36.00%), and one with mass=65.32 amu ( 64.00%) ? [Topic: isotope and molecular weight] 64.93...
-
In June 2003, IFAC issued an IAPS providing additional guidance for auditors internationally when they express an opinion on financial statements that are asserted by management to be prepared in...
-
Let U be a given universe with A, B U, |A B| = 3, |A U B| = 8, and |U| = 12. a) How many subsets C U satisfy A B C A U B? How many of these subsets C contain an even number of elements? AUBSDS...
-
The following is the statement of financial position (in abbreviated form) of Projections Ltd as at the end of this year: The following plans have been made for next year: 1 Revenue is expected to...
-
Because of a recession, the inflation rate expected for the coming year is only 3%. However, the inflation rate in Year 2 and thereafter is expected to be constant at some level above 3%. Assume that...
-
2 Solve the following logarithmic equation for x. 3 log (x+4)=6 X=
-
A 2.4 KVA, 2400/240 V 50 Hz step down transformer has the following parameters R = 1.52, X = 2.52, R2 = 0.022, X =0.032, Rc1 = 6k, Xm1 8 = It is operating at 80% of its rated load at 0.8 power factor...
-
Discuss the marketing trend concept given below and explain with 2 suitable examples. a) experiential marketing b)Buzz Marketing c)Viral Marketing d) Ambush Marketing e) Other current trends of...
-
Thak Ltd has a special order. After evaluating the order, it was revealed that this would result in a loss of $2m. In addition, Thak Limited incurred a loss of $6 in its normal operation. Thak...
-
This course was very challenging and engaging. I really enjoyed everything that I learned during this course that will help me run a successful business. What have you learned in this course and...
-
Discuss the relationship between the return on equity and flows to equity mutual funds
-
Discuss how the digital transformation has influenced traditional business management practices, emphasizing the role of technology in optimizing operations, decision - making, and customer...
-
Which portion of the given ip address 172.168.12.1 with default subnet mask of 255.255.0.0 represent the network portion ? 172.168.12 172.168 172.168.12.0 172
-
Hardin Services Co. experienced the following events in 2016: 1. Provided services on account. 2. Collected cash for accounts receivable. 3. Attempted to collect an account and, when unsuccessful,...
-
Fortune Company enters into a risk service agreement with the Chilean government. Fortune pays the government, in U.S. dollars, a \($5,000,000\) signing bonus and also agrees to pay all of the costs...
-
Ibis Company enters into a concession agreement with the British government. Ibis pays the government a \($10,000,000\) (U.S.) signing bonus and agrees to pay the government royalties of 8% of gross...
-
What does a high net wells to gross wells ratio indicate?
Study smarter with the SolutionInn App