Hau Lee Furniture, Inc., spends 45% of its sales dollars in the supply chain and finds its current profit of $16,000inadequate. The bank is insisting on an improved profit picture prior to approval of a loan for some new equipment.Hau would like to improve the profit line to $21,000 so he can obtain the bank's approval for the loan.SalesCost of materialCurrent Situation$80,000$36,000 (45%)Production costsFixed costProfit$16,000 (20%)$12,000 (15%)$16,000 (20%)a) What percentage improvement is needed in the supply chain strategy for profit to improve to $21,000? What is thecost of material with a $21,000 profit?A decrease of ☐ % in material (supply-chain) costs is required to yield a profit of $21,000, for a new material cost of(Enter your response for the percentage decrease to one decimal place and enter your response for the newmaterial cost as a whole number.)

a) Analysing Profit ImprovementProfit Increase Needed: $21,000 desired profit - $16,000 current…

Answered: Hau Lee Furniture, Inc., spends 45% of…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Provide answer for question C and D
Henri of Henri’s French Cuisine (HFC), a chain of twelverestaurants, is trying to decide if it makes sense to outsource thepurchasing function. Currently, Henri employs two buyers at anannual fi xed cost of $85,000. Henri’s estimates that the variablecost of each placed purchase order is $15. Value-Buy (VB), a groupof purchasing specialists, will perform the purchasing functionfor a fi xed annual fee of $100,000 plus $5 for each purchase orderplaced. Last year, HFC placed 1450 purchase orders.(a) Construct a base-case spreadsheet model that shows bothof these alternatives side-by-side. Use the same number oforders (stored in a single cell) to drive the calculations.(b) Using last year’s quantity of purchase orders, whichalternative would have been the better?(c) Use Goal Seek to fi nd the indiff erence point (where totalcosts are equal) between these two alternatives. (Hint: GoalSeek can work only with a single “Set cell.” Create a cell inyour model that computes the diff erence…
Hau Lee Furniture, Inc., spends 45% of its sales dollars in the supply chain and finds its current profit of $16,000 inadequate. The bank is insisting on an improved profit picture prior to approval of a loan for some new equipment. Hau would like to improve the profit line to $21,000 so he can obtain the bank's approval for the loan. Sales Cost of material Current Situation $80,000 $36,000 (45%) Production costs Fixed cost Profit $16,000 (20%) $12,000 (15%) $16,000 (20%) a) What percentage improvement is needed in the supply chain strategy for profit to improve to $21,000? What is the cost of material with a $21,000 profit? A decrease of 13.9 % in material (supply-chain) costs is required to yield a profit of $21,000, for a new material cost of $ 31000. (Enter your response for the percentage decrease to one decimal place and enter your response for the new material cost as a whole number.) b) What percentage improvement is needed in the sales strategy for profit to improve to…
Supply/Demand Info Predicted Sales Regular production Overtime production Subcontract production Ending inventory Hired employees Fired employees Total employees Cost variables are as follows: Cost Variables Labor cost/hour Overtime cost/ton Subcontracting costiton Holding cost ton/month Hiring cost employee Firing cost/employee Beginning Apr May 4,200 531 $20 $32 $25 $10 $3.700 $4.000 Jun 51,500 50.300 61,600 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/ton Regular production tons/employee/month Max regular production (tons/month) Max overtime production (tons/month) Max subcontractor production (tons/month) 3 100 56,700 3,700 6,000 Jul Aug Sep 45,400 56.600 62,800 Given the above information (and don't overlook beginning number of employees and inventory levels in the first table), create a LEVEL production plan with only the use of regular production and no inventory left over at the end of the six-month period. What is the regular…
Hau Lee Furniture, Inc., spends 45% of its sales dollars in the supply chain and finds its current profit of $15,000 inadequate. The bank is insisting on an improved profit picture prior to approval of a loan for some new equipment. Hau would like to improve the profit line to $20,000 so he can obtain the bank's approval for the loan. Sales Cost of material Current Situation $100,000 $45,000 (45%) Production costs Fixed cost Profit $25,000 (25%) $15,000 (15%) $15,000 (15%) a) What percentage improvement is needed in the supply chain strategy for profit to improve to $20,000? What is the cost of material with a $20,000 profit? A decrease of ☐ % in material (supply-chain) costs is required to yield a profit of $20,000, for a new material cost of (Enter your response for the percentage decrease to one decimal place and enter your response for the new material cost as a whole number.)
Problem 16-11 (Algo) One of your Taiwanese suppliers has bid on a new line of molded plastic parts that is currently being assembled at your plant. The supplier has bid $0.10 per part, given a forecast you provided of 100,000 parts in year 1; 300,000 in year 2; and 500,000 in year 3. Shipping and handling of parts from the supplier's factory is estimated at $0.01 per unit. Additional inventory handling charges should amount to $0.003 per unit. Finally, administrative costs are estimated at $30 per month. Although your plant is able to continue producing the part, the plant would need to invest in another molding machine, which would cost $20,000. Direct materials can be purchased for $0.05 per unit. Direct labor is estimated at $0.04 per unit for wages plus a 50 percent surcharge for benefits and, indirect labor is estimated at $0.011 per unit plus 50 percent benefits. Up-front engineering and design costs will amount to $50,000. Finally, management has insisted that overhead be…
PLEASE SOLVE ON EXCEL AND SHOW ME STEP BY STEP WITH SCREENSHOTS OF YOUR EXCEL BECAUSE I WILL PRESENT IT IN CLASS.
Please help with 10-7, 10-8, and 10-19 please explain and give examples
Kamal Fatehl, production ma nager of Kennesaw Manufacturing, finds his profit at $15,000 (as shown in the following statement)- inadequate for expanding his business. The bank isinsisting on an improved profit picture prior to approval of a loan for some new equipment. Kamal would like to improve the profit line to $25,000 so he can obtain the bank's approval for the loan. a) What percentage improvement is needed in a supply chain strategy for profit to improve to $25,000? What is the cost of material with a $25,000 profit?b) What percentage improvement is needed in a sales strategy for profit to improve to $25,000? What must sales be for profit to improve to $25,000?
Problem 9a: Jones Surgicenter uses 90,000 bags of IV solution annually. The optimal safety stock (which is on hand initially) is 1,000 bags. Each bag costs the center $1.50, inventory carrying costs are 20 percent, and the cost of placing an order with the supplier is $15. Problem 9b: Continuing with the previous question, what is the total inventory cost, TIC? Do not include the dollar sign in your answer.
Please answer D & E.
The Eagle Machine Company averaged $2 million in inventory last year, and the cost of goods sold was $10 million. Figure 12.5 shows the breakout of raw materials, work-in-process, and finished goods inventories. The best inventory turnover in the company’s industry is six turns per year. If the company has 52 business weeks per year, how many weeks of supply were held in inventory? What was the inventory turnover? What should the company do?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS