Description
Using excel spread sheet please answer the following question.
I have attached a picture of the question
Unformatted Attachment Preview
Jacob's Convenience Store is a chain of Gas Station/Convenience Stores with multiple locations that is
growing rapidly. Zachary, the manager of operations is constantly on the lookout for new locations. To
assist in choosing good locations, Zachary has gathered data from the current stores. That data can be
found in the file Jacobs.xlsx. The data gathered include:
Variable
Description
Annual Sales: Annual Sales/$1000's
SqFt:
Building size in square feet/1,000
Inventory:
Inventory levels/$1000
Advertising: Advertising Dollars/$1,000
Size of District: Number of families in the area/1,000
No Competing Stores: The number of competing stores in the area
Zachary has the possibility of opening a new store with the following characteristics:
SqFt:
3,000
Inventory:
$450,000
Advertising:
$12,000
Size of District: 11,000
No Competing Stores: 10
Zachary has requested that you provide him with the following information.
1. What is your prediction for annual sales in the new store? Please show your work.
2. Of the three variables that Zachary can control: SqFt, Inventory, and Advertising, which variable
contributes the most to annual sales? What is the second most important contributor to sales?
If Zachary spends an additional $1,000 on each of these three items how much will they
individually contribute to annual sales?
3. How confident are you in your calculation of annual sales?
4. Keeping all other parameters above constant, how large in SqFt, would a store need to be in
order to generate $1,000,000 in sales? Is a store of that size practical given the size of the
current stores? Explain.
Assignment:
Analyze the data, answer the questions. For the sake of simplicity you may place your answers in the
spreadsheet in a textbox. When completed, upload your workbook to the appropriate D2L dropbox.
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Review
Review
Anonymous
Awesome! Perfect study aid.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Content
Statistics Question
Must know Theoretical Statistics and R programming language to do this. The question file and .R file for these are attach...
Equation of Tangent Line Mathematics Questions
Total ________/100___
Keep all answers as exact values or values with two decimals.
1. (15 marks) Use the first principle ...
Need Geometry help with the center of a circle
...
Practices for Inventory Management - Inventory Costs Video Essay
Link video: https://www.youtube.com/watch?v=3qLV6tfLfk0 The video on 8 best practices for inventory management pr...
MATH 192 Diablo Valley College Math Functions and Domains Exercises
If you know mathematics well, you can take the order. I will give you the document after you take the order...
PLEASE ANSWER CORRECTLY!
Find three ordered pairs that result from the rule . Use at least one positive value and one negative value. &...
