Question: I need all the excel steps in a proper and legible way in a detailed way. A F L 1 7 B G A company

I need all the excel steps in a proper and legible way in a detailed way.

A F L 1 7 B G A company has five factories and four markets to supply to. The manufacturing cost in each factory, transport cost, average demand in each market, standard devintion of demand in each market and supply limit is given below. SP is the selling price per unit. Assume that amount sold total of averag: demand The company must supply enough to each market that demand will be met 80% of the time (Probability Demand-Amount supplied =0.8), Unisold units have a salvage value of Rs 30). Find out how much is being transported from each factory to ench markes, and the SP, which maximises proti 3 4 5. Market 1 Market 4 Supply 6 7 Market 2 21 Marker 3 29 Manufacturing cost 35 300 0 22 28 25 11 14 50 Factory A Factory B Factory C Factory D Factory E 9 16 16 17 11 12 21 37 61 300 300 300 300 35 40 10 11 12 23 22 15 37 22 50 300-SP 13 Average demand 14 Stde 13 400-1.55T 600-4.55P 500-2.55 100 RO 75 60 10 12 18 19 20

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Everlane Inc. (Everlane) was a clothing retailer selling modern, everyday basics, such as white T-shirts, jeans, and backpacks. To set itself apart from other apparel retailers, the company engaged...

GLOBAL SOURCING AT NIKE 1. Identify the Ethical dilemma in the case 2. Alternatives to Ethical Dilemma 3. Conclusion of the Case NaE.N-HE MSIE.A MicaA at. W. Tcozsi.1. C.HviA Hu i. Global Sourcing at...

Up until the time of the COVID-19 crisis, what has been the basis of Lenovo's competitive advantage? How has it managed to leverage its global operations to increase both market share and efficiency?...

incorrect document, we'll assume that the homework assignment was not actually completed. Background DBVac is considering adding an additional product to their lineup. The company's Research and...

In this assignment, you'll be writing a business case in which you will recommend to DBVac which of the three vacuums to bring to market, give them a sense for what to expect from its release in...

TRANSPARENCY AND ETHICS AT EVERLANE Everlane was a clothing retailer of modern, everyday basics, such as white t-shirts, jeans, and backpacks. To set themselves apart from other apparel retailers,...

Below is the Case Reading: TRANSPARENCY AND ETHICS AT EVERLANE Everlane was a clothing retailer of modern, everyday basics, such as white t-shirts, jeans, and backpacks. To set themselves apart from...

I have attached both the chapters from which you will be answering the following question. Ch 8 (p 387 of text or p 35 of the pdf) ?Exercise D. Prepare the bank reconciliation and any required...

1. Criticize the attached article Your project work is based on a research work (case studies done using system analysis technique). Read the paper carefully and understand the intent of the research...

Use the Poisson probability function to determine the following probabilities: a. For = 2, P(x = 5) b. For = 6, P(x = 2) c. For = 3.5, P(x = 0) d. For = 2, P(2

After a company has been incorporated, it has to apply for a certificate to commence business before it can start operating formally. Outline the information that has to be provided in the returns...

Jaime, who is blind, wants his employer to hire a reader to assist him. His employer has seventy five employees and is concerned about the extra expense. The employer must prove that the proposed...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...