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

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

Purchasing Power Parity, Assume that a Mazda 2 sells for 16,000 Australian ...

Assume that a Mazda 2 sells for 16,000 Australian dollars in Australia and 10,000 Canadian dollars in Canada If purchasing-power parity holds, what is the Canadian dollar/Australia

Define the interpreting the price elasticity of demand, Define the interpre...

Define the interpreting the price elasticity of demand. Interpreting the Price Elasticity of Demand: Demand is: a. Elastic when the price elasticity of demand is greater

Production possibility curve, PRODUCTION POSSIBILITY CURVE As we have s...

PRODUCTION POSSIBILITY CURVE As we have seen, the essence of economic analysis is the problem of scarcity and choice. We know that limited productive resources compel individua

Give example to calculate the price level, Give example to calculate the pr...

Give example to calculate the price level Imagine that we have created a particular basket of services and goods. We calculate price level at four different points in time duri

International trade, why is international trade important south africa

why is international trade important south africa

Cumulative external cost of production, A textile mill releases pollution i...

A textile mill releases pollution into nearby wetlands, and the associated health and ecological damages are not considered in the private market. Suppose you observe the following

Nominal interest rate of 15% compounded annually, An investor has a series ...

An investor has a series of three $15,000 payments expected to be realized at the end of years three, four, and five. Calculate the present value P at time zero and the correspondi

Derive saving - investment method, Derive saving- investment recognize in t...

Derive saving- investment recognize in the context of an open economy. From national income accounting shows that an enhance in taxes (whereas transfer unchanged) must imply a

Determine the total value of loan in an economy, The total value of loan in...

The total value of loan in an economy is Rs. 400 million and the reserve ratio is 20 per cent. An enhance of Rs. 15 million in the money which the public keeps in commercial ba

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