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

Taxation, with reference to incidence of taxation, explain with the help of...

with reference to incidence of taxation, explain with the help of a diagrams, who bears the incidence of taxation when the demand for a commodity is (i)perfectly inelastic (ii) uni

Explain herzbergs factor theory of motivation, Question 1: "Motivation ...

Question 1: "Motivation denotes to the degree of readiness of an organism to pursue some designated goal and implies the evaluation of the nature and locus of the forces, inclu

Wholesale prices, Wholesale Prices, Consumer Prices and Inflation   From...

Wholesale Prices, Consumer Prices and Inflation   From the man on the street to the highest policy makers, the behavior of prices is of intimate concern. Prices determine the pu

Assignment , I want you to solve problem in Macroeconomics.It is in the fil...

I want you to solve problem in Macroeconomics.It is in the file attachment.

Financing of the external payments deficit, Financing of the external payme...

Financing of the external payments deficit: The trend  in India's widening CAD during the second half of  the eighties, both in absolute terms and also as a proportion of the

Help needed, what are the advantages and disadvantages of unemployment

what are the advantages and disadvantages of unemployment

Determine the gross domestic product, Determine the Gross domestic product ...

Determine the Gross domestic product Gross domestic product is the total value of an economy's domestic output of goods and services. Gross national product is the similar as

Describe the corresponding equilibrium strategies, Only two identical firms...

Only two identical firms i = A;B, each with marginal cost MCi = 40 and no fixed cost, operate in a market with demand: Q     p 1    160 2    120 3     90 4     70

Economics 10, The demand for money schedule shows that the quality of money...

The demand for money schedule shows that the quality of money that people want to hold

Unemployment, Who is considered unemployed?

Who is considered unemployed?

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