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

Find out fixed cost and average cost, Sara runs a small business assembling...

Sara runs a small business assembling personal computers. This table shows her total cost at different levels of output. Number of computers produced

the effect of on reserves and the monetary base, Many developing countries...

Many developing countries have suffered banking crises in which depositors lost part or all of their deposits (in some countries there is no deposit insurance). This type of crisis

Trade between the two countries, Given the above trade between the two coun...

Given the above trade between the two countries, explain the trade effects on product prices, and factor incomes. Why do these effects occur?

Compute the npv-the irr the mirr, Suppose a company is considering two inde...

Suppose a company is considering two independent projects, Project A and Project B.  The cash outlay for Project A is $14,000. The cash outlay for Project B is $20,000. The company

Calculate the npv for discount rates, Shambles, a large toy retailer, are l...

Shambles, a large toy retailer, are looking at bringing out a new range of soft toys. The range under consideration is "Mythical Beasts."  The "Mythical Beasts" range will cost £50

Price - macroeconomy relationship, There are many other macroeconomic indic...

There are many other macroeconomic indicators which one might expect to be affected following an oil price hike. Perhaps more obviously affected than GNP is inflation. DePratto et

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."

Balance between automation and labor, Businesses often decide between using...

Businesses often decide between using automation and labor in production. An automotive environment may have high fixed costs and low variable costs, and an industry that utilizes

Democracy survive if a majority of the citizen, Can democracy survive if a ...

Can democracy survive if a majority of the citizen pays little or nothing in taxes while benefiting directly from a higher level of government spending? Why or why not?

Balance of trade, Balance of T rade A country's present accoun...

Balance of T rade A country's present account reflects a money drain when exports exceed imports. The net distinction in-between the dollar value of a world imports an

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