Sanjana's Sweet Shoppe operates on the boardwalk of a New England coastal town. The store only opens for the summer season and the business is heavily dependent on the weather and the economy in addition to new competition. Sanjana Sweet, the owner, prepares a budget each year after reading long-term weather forecasts and estimates of summer tourism. The budget is a first step in planning whether she will need any loans and whether she needs to consider adjustments to store staffing. Based on expertise and experience, she develops the following. Gross Margin per Customer (Price - Cost of Goods) $6.5 Number of Scenario Customers Good 45, 000 35, 000 30, 000 Fair 5.5 Poor 1.9 Sanjana assumes, for simplicity, that the gross margin and the estimated number of customers are independent. Thus, she has nine possible scenarios. In addition to the cost of the products sold, Sanjana estimates staffing costs to be $45,000 plus $2 for every customer in excess of 35,000. The marketing and administrative costs are estimated to be $12,900 plus 3 percent of the gross margin.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
Requlred:
Prepare an analysis of the possible operating income for Sanjana similar to that in Exhibit 13.15. What is the range of operating
incomes?
Gross
Margin
Number of
Customers
Operating
Costs
Marketing &
Admin
Operating
Profit (Loss)
Gross Margin
Poor
1.9
30,000
Fair
30,000
30,000
35,000
5.5
Good
$4
6.5
Poor
1.9
Fair
24
5.5
35,000
Good
6.5
35,000
Poor
S.
1.9
45,000
Fair
%24
5.5
45,000
45,000
Good
6.5
Transcribed Image Text:Requlred: Prepare an analysis of the possible operating income for Sanjana similar to that in Exhibit 13.15. What is the range of operating incomes? Gross Margin Number of Customers Operating Costs Marketing & Admin Operating Profit (Loss) Gross Margin Poor 1.9 30,000 Fair 30,000 30,000 35,000 5.5 Good $4 6.5 Poor 1.9 Fair 24 5.5 35,000 Good 6.5 35,000 Poor S. 1.9 45,000 Fair %24 5.5 45,000 45,000 Good 6.5
Exercise 13-47 (Algo) Sensitivity Analysis (LO 13-9)
Sanjana's Sweet Shoppe operates on the boardwalk of a New England coastal town. The store only opens for the summer season and
the business is heavily dependent on the weather and the economy in addition to new competition. Sanjana Sweet, the owner,
prepares a budget each year after reading long-term weather forecasts and estimates of summer tourism. The budget is a first step in
planning whether she will need any loans and whether she needs to consider adjustments to store staffing. Based on expertise and
experience, she develops the following.
Gross Margin per
customer
(Price - Cost of
Goods)
$6.5
5.5
1.9
Number of
Scenario
Good
Fair
customers
45, 000
35, 000
30, 000
Poor
Sanjana assumes, for simplicity, that the gross margin and the estimated number of customers are independent. Thus, she has nine
possible scenarios. In addition to the cost of the products sold, Sanjana estimates staffing costs to be $45,000 plus $2 for every
customer in excess of 35,000. The marketing and administrative costs are estimated to be $12,900 plus 3 percent of the gross margin.
Transcribed Image Text:Exercise 13-47 (Algo) Sensitivity Analysis (LO 13-9) Sanjana's Sweet Shoppe operates on the boardwalk of a New England coastal town. The store only opens for the summer season and the business is heavily dependent on the weather and the economy in addition to new competition. Sanjana Sweet, the owner, prepares a budget each year after reading long-term weather forecasts and estimates of summer tourism. The budget is a first step in planning whether she will need any loans and whether she needs to consider adjustments to store staffing. Based on expertise and experience, she develops the following. Gross Margin per customer (Price - Cost of Goods) $6.5 5.5 1.9 Number of Scenario Good Fair customers 45, 000 35, 000 30, 000 Poor Sanjana assumes, for simplicity, that the gross margin and the estimated number of customers are independent. Thus, she has nine possible scenarios. In addition to the cost of the products sold, Sanjana estimates staffing costs to be $45,000 plus $2 for every customer in excess of 35,000. The marketing and administrative costs are estimated to be $12,900 plus 3 percent of the gross margin.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education