Estimate the maximum possible daily profit, Macroeconomics

Assignment Help:

Shambles have selected the "Mythical Beasts" range and decided to concentrate on "Pegasus" and "Phoenix." They would now like to find the right mix of these two products in order to maximise profit. Each toy has to go through two processes during manufacture: sewing and stuffing.

Pegasus takes 30 minutes to sew whilst Phoenix takes 20 minutes; there are 10 hours (600 minutes) available for sewing each day.

Pegasus takes 20 minutes to stuff whilst Phoenix takes 25 minutes; there are 10 hours (600 minutes) available for stuffing each day.

Pegasus generates £4 profit per toy whilst Phoenix generates £5 profit per toy.

What is the maximum possible daily profit, and how many of each product should be produced in order to achieve this?

Use "Solver" in Microsoft Excel to solve this problem. Include:

a print-out of cell values
a print-out of cell formulae
a print-out of the Solver dialogue box with optimisation conditions and constraints
an Answer Report from Solve
a statement of the answer in words

 


Related Discussions:- Estimate the maximum possible daily profit

Control of ochratoxin, Q. Control of ochratoxin? Control: Once ochratox...

Q. Control of ochratoxin? Control: Once ochratoxin A has been formed in a food, it is difficult to remove by most forms of food processing. Cooking with or without previous soa

Price of gasoline has recently come down, The price of gasoline has recentl...

The price of gasoline has recently come down as has the quantity. Show graphically and explain what might have caused this.

Peace time goods and war time goods, Draw the PPC model of peace time goods...

Draw the PPC model of peace time goods and war time goods and describe its characteristics. Label point A as being more toward peace time goods than war time goods and show graphic

Estimate the optimal level of provision, There are a lot of mosquitoes in ...

There are a lot of mosquitoes in the island of Liholiho. Only two people live in this island, Robinson Crusoe and Man Friday. Their respective demand curves for mosquito control ar

frame work, Hello sir, madam... I am hassan PHD student. I''m lost to get...

Hello sir, madam... I am hassan PHD student. I''m lost to get a good frame work of my thesis about e government and economic growth. and I need to know how to measure the variable

Best estimate of real gdp, Consumption = $3 trillion, Investment spending =...

Consumption = $3 trillion, Investment spending =$2 trillion, Government purchases = $2 trillion, net exports via the ROW is $0 trillion. 1. What is the best estimate of real GDP

Direct foreign investment, An example of direct foreign investment is given...

An example of direct foreign investment is given by: a. The sale of U.S. government bonds to foreigners. b. The sale of U.S. stocks (equities) to foreigners. c. A multinational cor

Number of gallons of paint, The number of gallons of paint that Home Depot ...

The number of gallons of paint that Home Depot sells in a given day is normally distributed with a mean of 150 gallons and a standard deviation of 35 gallons (I realize that the di

Investment, What are the basic differences between the investment curve and...

What are the basic differences between the investment curve and an investment demand curve for an economy

Determine the real rate of return on investment, A) Suppose Jean Splicer, a...

A) Suppose Jean Splicer, an investor, buys $300,000 of shares of stock in a diversified bundle of Bio-tech firms and exactly one year later sells those shares for $315,000. Assume

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd