Construct spreadsheet model to analyze wallys decision

Assignment Help Operation Management

Reference no: EM13991250

In February, Wally Wade, owner of Bama Fan Supplies, Inc., must place an order with Nike for the new Alabama football shirts for the coming season. The long lead time is required for the contract manufacturers in Asia to order the necessary materials and to begin production in April. The shirts will be delivered to Wally in early-August just in time for the new season. Nike will charge Wally $50 for each shirt he orders, and he will sell each shirt for $75 during the season. There will not be another opportunity for Wally to order any more shirts if he runs out. At the end of the season Wally will sell all the shirts that are left at a price of $15. Obviously, Wally doesn’t know exactly what the demand for these shirts will be, but during the past couple of years he has sold an average of 500 shirts each season. a. Draw an influence chart for this problem. b. Construct a spreadsheet model to analyze Wally’s decision. Use an order quantity of 600 and a demand of 525 for your base case values

Reference no: EM13991250

Questions Cloud

What kind of employee social contract : What kind of employee social contract is assumed by Kirby and Cunningham? Explain. If you were an HR manager at the company, which view would you support? Why?. HR department hire and develop human capital tp serve the organization's strategy and dri..

Which of the following immune system cells i : Which of the following immune system cells is the target of the human immunodeficiency virus? a. cytotoxic T cells b. neutrophils

Determining the primary source of income : Determine how each of the following expenses would be deducted for tax purposes. If the expense is not deductible, explain why not. Chander paid $500 in interest on a loan he used to purchase equipment for his retail business.

Determine the expected duration of the entire project : Determine the expected duration of the entire project, showing all of your work or reasoning. Determine the slack for project Activity E, showing all of your work or reasoning.

Construct spreadsheet model to analyze wallys decision : In February, Wally Wade, owner of Bama Fan Supplies, Inc., must place an order with Nike for the new Alabama football shirts for the coming season. The long lead time is required for the contract manufacturers in Asia to order the necessary materials..

Are daughter cells that is produced in meiosis identical : Are daughter cells that is produced in meiosis identical? how many chromosomes in daughter cells produced by meiosis compared with mitosis?

Medical insurance premiums on her employees : Discuss how an individual would deduct each of the following expenditures. If more than one treatment is possible, discuss the circumstances under which each type of deduction would be obtained:

A human male : Fill in the blanks A human male has _____ homologous chromosomes and a human female has _____ homologous chromosomes.

Generation plagiarism by trip gabriel : "Generation plagiarism" by trip gabriel, Copying and pasting from the web is just like copying from a book. But too many students either don't know that it's cheating-or don't care. (from the new-york times Upfront, Vol. 143, October 25, 2010)

User Account

All Pages