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

Interest rates and inflation, Q. Interest rates and inflation? Assume y...

Q. Interest rates and inflation? Assume you have 1 million on 1st January 2008. A basket of services and goods similar to the CPI basket costs 100,000. You can then purchase ex

MR, Question 1: Consider a two-period, two-person pure exchange economy. Ut...

Question 1: Consider a two-period, two-person pure exchange economy. Utility functions and endowments are given as follows. u1(x0; x1) = (x0x1)2 and e1 = (18; 4) u2(x0; x1) = ln x0

Uninsured patients are expected to pay, A radiology firm charges $2,000 per...

A radiology firm charges $2,000 per exam. Uninsured patients are expected to pay list price. How much do they pay?

Calculate the equilibrium price and quantity, Question 1: What is the equi...

Question 1: What is the equilibrium price and quantity? Question 2: How do you describe the market situation, if the market price is higher than the equilibrium price? Qu

Why do some countries have a high real per capita income, Why do some count...

Why do some countries have a high real per capita income? High standard of living within the industrialized nations consider to be largely because of the high productivity of

Income Distribution, Researchers have put forth various theories to explain...

Researchers have put forth various theories to explain the observed widening of the income distribution in the United States over the past four decades. First, there has been a sh

Prices in the market, Who sets the prices in the market and what is the nat...

Who sets the prices in the market and what is the nature of competition? Is it buyer versus sellers or buyer versus buyers? What happens if the price is too high or too low? Is the

Explain ad-curve at a given point in time, AD-curve, just like before, disp...

AD-curve, just like before, displays combinations of Y and P where both goods market and money market are in equilibrium. At any given instance, even when we have inflation, aggreg

Effects of fiscal policy, (Effects of Fiscal Policy) Recently some legislat...

(Effects of Fiscal Policy) Recently some legislators have called for tax increases to reduce the federal budget deficit. Conservatives have countered that such tax increases could

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