Jesse to calculate profit for sales of backpacks

Assignment Help Project Management

Reference no: EM13952902

Jesse Jones, a budding entrepreneur, has set up a small backpack company and wants to distribute the backpacks exclusively through the local bookstore. There are three models, of backpacks: canvas, nylon, and leather. The bookstore expects demand to be somewhere between 15 and 40 for each model and Jesse wants to develop a spreadsheet model to analyze the sensitivity of profit to various inputs. The bookstore has agreed to pay Jesse $35.50 for each canvas backpack, $42.50 for each nylon backpack, and $69.50 for each leather backpack. Labor costs will be $7 per hour for sewing canvas, $8 per hour for sewing nylon and $9 per hour for sewing leather. The following table provides additional information about the production costs for each backpack.

	Canvas	Nylon	Leather
Yards per backpack	2.25	2.1	2.6
Cost per yard	$4.50	$7.65	$9.45
Sewing hours per backpack	1.5	1.7	1.9

a. Create a spreadsheet model for Jesse to calculate profit for sales of the backpacks (one model.) Demand and production quantity for each of the three models are uncertain variables.

b. Use Excel Data Table (one-way) to show the profit sensitivity to the per yard cost of leather.

Use cost per yard values 9.00, 9.50, 10.00, 10.50, 11.00, 11.50, 12.00

Create a graph to display results from the Data Table

c. Use Excel Data Table (two-way) to show the profit sensitivity to the demand and production quantity for nylon backpacks.

Use quantities of 10, 20, 30, 40, 50

Reference no: EM13952902

Questions Cloud

What are three important properties of a normal distribution : The following questions pertain to some important facts to know about a normal distribution: What are three important properties of a normal distribution?

Write an if-then statement for the following code : Write an array that stores the square of the numbers from 1 to 5 in each element. Write out each element.

Quoting, paraphrasing, and summarizing : What is the difference between quoting, paraphrasing, and summarizing? What type of citation is required for each? Why is properly citing sources important?

Determine the probability density function : Define the probability density and cumulative probability function for an absolutely continuous random variable. Which of these functions is analogous to the probability mass function of a discrete random variable?

Jesse to calculate profit for sales of backpacks : Create a spreadsheet model for Jesse to calculate profit for sales of the backpacks (one model.) Demand and production quantity for each of the three models are uncertain variables.

Describe why the fraud was committed and amount of loss : write a report on the article, including if described in the article items to report on: perpetrator info, why the fraud was committed (motive), amount of loss (damages).

Calculate the probability of the child having the disease : For each parent there is a 50-50 chance that the child will inher- it either the dominant or the recessive gene. Calculate the probability of the child having the disease if: Both parents are carriers and One parent is a carrier and the other..

When two pointer variables point to the same memory location : Using the precedence rules of APL, the value of the expression 24 x 3 + 1 is 73.

Write a succinct introduction that informs reader of topic : Introduction: Write a succinct introduction that informs the reader of the topic of the assignment and its organization. Remember, an effective essay introduction tells the reader what you will say

User Account

All Pages