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

Rent control agency of new york city, The rent control agency of New York C...

The rent control agency of New York City has found that market demand is QD=100-5P With quantity measured in tens of though sands of apartments and price, the monthly rental rate,

Fiscal, what is the supply side

what is the supply side

Revealed preference approach, REVEALED PREFERENCE APPROACH The downward...

REVEALED PREFERENCE APPROACH The downward slope of the demand curve was justified on the basis of utility derived by the consumer. But specification of consumer tastes in form

The structural deficit, The structural deficit: A. falls as the economy exp...

The structural deficit: A. falls as the economy expands and rises when it contracts. B. changes as actual income changes regardless of potential income. C. does not change when inc

Pros and cons of commercial transactions, Examine the pros and cons of comm...

Examine the pros and cons of commercial transactions in blood from the egoistic, the utilitarian, and the Kantian perspectives

Government in the cross model, The government in the cross model ...

The government in the cross model Net taxes NT(Y) depends positively on real GDP in the cross model In this model when national income increase

Liberalisation and trends in fdi, Foreign Direct Investment and Development...

Foreign Direct Investment and Development: In neo-classical economic theory, FDI involves  the movement of capital from capital abundant  to capital scarce host countries. Mun

Find the compensating variation , Joe has preferences over pizza (p) and be...

Joe has preferences over pizza (p) and beer (b) given by U = pb. The marginal utilities are MU p = b and MU b = p, and Joe's income is I = 60. 1. Find Joe's optimal consumptio

Walmarts website, Over the past month, the 500 customers have downloaded th...

Over the past month, the 500 customers have downloaded the following number of songs from WalMart's website (obviously, they have had more, but we need to use workable numbers): 13

NATIONAL INCOME VARIATION, give and explain the different causes of nationa...

give and explain the different causes of national income variation

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