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

Purchase an annuity, Suppose you have $10,000 and wish to purchase an annui...

Suppose you have $10,000 and wish to purchase an annuity that pays you a fixed dollar amount every month. How much would you receive each month if the annuity rate is 1% and you in

Gross domestic product, In 1 to 2 sentences respond to the following commen...

In 1 to 2 sentences respond to the following comment. "Pollution restrictions will reduce gross domestic product and therefore hurt the economy."

Gdp, The following is the information from the national income accounts for...

The following is the information from the national income accounts for a hypothetical country: GDP Rs. 6000.00 Gross Investment Rs. 800.00 Net Investment Rs. 200.00 Consumption Rs.

Price of its cabernet sauvignon, When Sonoma Vineyards reduces the price of...

When Sonoma Vineyards reduces the price of its Cabernet Sauvignon from $15 a bottle to $12 a bottle, the result is an increase in a. the demand for this wine b. the supply of

Define the term - productivity, Define the term - Productivity Producti...

Define the term - Productivity Productivity is the concept which measures how outputs can be maximised from given inputs. In factories labour productivity is normally calculate

Institutional setting for trade policy formulation, Institutional Setting f...

Institutional Setting for Trade Policy Formulation: While the Ministry of Commerce has the main responsibility of formulating India's trade policy, it also seeks policy inputs

Wage rate increases, A person chooses between leisure and consumption. All ...

A person chooses between leisure and consumption. All of their consumption comes from current income. The utility derived from any combination of leisure and consumption is given b

Unusually high period, The consumer price index for the 1978-82 periods and...

The consumer price index for the 1978-82 periods and the GDP deflator follow. This was a period of unusually high, but declining, inflation. (The CPI is equal to 100 in the base ye

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