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

Reviews

Write a Review

Project Management Questions & Answers

  Create a project schedule and align resources

Create a project schedule and align resources, Analyze project schedule and resource allocation

  Managerial roles and gap analysis

Write a report on Managerial Roles and Gap Analysis

  Questionaire on project management

Questionaire on Project Management

  Describe the market growth rate for product

Describe the market growth rate for product and service.

  Prepare a work plan and project schedule - gantt chart

Design an online system for the human resources department to manage available job positions.

  Project risk management approach

How does a project risk management approach pro-vide an early warning signal for impending problems or issues

  Black-scholes options pricing model

Calculate the payoff and the profits for investments

  Describe the features or characteristics of product

Describe the features or characteristics of your product or service.

  Write paper on inventory management system

Write paper on Inventory Management System.

  Analysis of the overall project risk

Analysis of the overall project risk

  Investment and performance analysis

Evaluate the usefulness of ROCE

  Distribution strategy and project management

Distribution strategy and project management

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