1. Classify each cost as fixed or variable (see below) 2. Calculate the annual cost for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Classify each cost as fixed or variable (see below) 2. Calculate the annual cost for cost description (see below) Using the cost and sales data below, prepare Income Statements (to the 3. right) based on the criterion provided. ALL YELLOW CELLS REQURE DATA TO BE INPUT (START BELOW) Classify Annual GENERAL BUSINESS COSTS Cost Cost $ 6,000 $ 1,800 Rent Monthly 500 FIXED Utilities Monthly 150 FIXED Insurance Annually $ 800 FIXED 800 Water Quarterly s 150 FIXED 600 Coffee Making Equipment - Depreciation (based on cost of $12,000 and a 5 year life and zero salvage value) Annually $ 2,400 $ 1,200 FIXED Table and Chair Rental Monthly 100 FIXED Laptop and Credit Card Scanner - Depreciation (based on cost of $4,800 with a 4 year useful life and zero salvage value) Barrista Salary Annually $ 1,200 $ 25,000 $ 1,800 FIXED Annually 25,000 FIXED 150 FIXED Other Miscellaneous Costs Monthly COST OF CUP OF COFFEE Coffee Grounds рer cup 0.75 VARIABLE Sugar/Cream/Flavoring per cup 0.05 VARIABLE Paper Cup and Top per cup 0.12 VARIABLE Heat Protection Sleeve per cup 0.05 VARIABLE Plastic Stirrer per cup 0.03 VARIABLE SALES PRICE OF COFFEE per cup 4.00 INCOME STATEMENT SLEIVINIO CVIVOE I (COMPARED TO BASE (COMPARED TO BASE (COMPARED TO BASE SCENARIO) BREAK EVEN POINT BASE SCENARIO SCENARIO) SCENARIO) What Happens to Net Income if I Use What Happens to Net Income if I Spend $5,000 on Advertising Grounds Costing $1.25 SCENARO AND BRING Premium Kona Coffee YOU CREATE A Annual Target Net Income of $60,000 and Cups of Coffee per cup and Cups of IT TO THE At Break Even Point Increases 10%? Coffee Increases 8%? DISCUSSION GROUP Sales Revenue Variable Costs Contribution Margin Fixed Costs 40,800 40,800 Net Income (40,800) $ (40,800) S BREAK EVEN POINT CALCULATION BASED ON THE SCENARIO ABOVE -Cups of Coffee -Sales Revenue CM Ratio: -Dollars -Ratio 1. Classify each cost as fixed or variable (see below) 2. Calculate the annual cost for cost description (see below) Using the cost and sales data below, prepare Income Statements (to the 3. right) based on the criterion provided. ALL YELLOW CELLS REQURE DATA TO BE INPUT (START BELOW) Classify Annual GENERAL BUSINESS COSTS Cost Cost $ 6,000 $ 1,800 Rent Monthly 500 FIXED Utilities Monthly 150 FIXED Insurance Annually $ 800 FIXED 800 Water Quarterly s 150 FIXED 600 Coffee Making Equipment - Depreciation (based on cost of $12,000 and a 5 year life and zero salvage value) Annually $ 2,400 $ 1,200 FIXED Table and Chair Rental Monthly 100 FIXED Laptop and Credit Card Scanner - Depreciation (based on cost of $4,800 with a 4 year useful life and zero salvage value) Barrista Salary Annually $ 1,200 $ 25,000 $ 1,800 FIXED Annually 25,000 FIXED 150 FIXED Other Miscellaneous Costs Monthly COST OF CUP OF COFFEE Coffee Grounds рer cup 0.75 VARIABLE Sugar/Cream/Flavoring per cup 0.05 VARIABLE Paper Cup and Top per cup 0.12 VARIABLE Heat Protection Sleeve per cup 0.05 VARIABLE Plastic Stirrer per cup 0.03 VARIABLE SALES PRICE OF COFFEE per cup 4.00 INCOME STATEMENT SLEIVINIO CVIVOE I (COMPARED TO BASE (COMPARED TO BASE (COMPARED TO BASE SCENARIO) BREAK EVEN POINT BASE SCENARIO SCENARIO) SCENARIO) What Happens to Net Income if I Use What Happens to Net Income if I Spend $5,000 on Advertising Grounds Costing $1.25 SCENARO AND BRING Premium Kona Coffee YOU CREATE A Annual Target Net Income of $60,000 and Cups of Coffee per cup and Cups of IT TO THE At Break Even Point Increases 10%? Coffee Increases 8%? DISCUSSION GROUP Sales Revenue Variable Costs Contribution Margin Fixed Costs 40,800 40,800 Net Income (40,800) $ (40,800) S BREAK EVEN POINT CALCULATION BASED ON THE SCENARIO ABOVE -Cups of Coffee -Sales Revenue CM Ratio: -Dollars -Ratio
Expert Answer:
Answer rating: 100% (QA)
INCOME STATEMENT Break Even Point Base Scenario Scenario 1 Scenario 2 Scenario 3 Break Even Point Ba... View the full answer
Related Book For
Fundamental Managerial Accounting Concepts
ISBN: 978-1259569197
8th edition
Authors: Thomas Edmonds, Christopher Edmonds, Bor-Yi Tsay, Philip Olds
Posted Date:
Students also viewed these mathematics questions
-
Fill in the cells in column B with groups in terms of the value in column A in tab Q2, and the range of each group lies in the table on the right side. For example, if the value is 5.5, the group...
-
30) Calculate the annual cost for commercial paper (CP) on a $10,000,000 CP issue with a 60-day maturity at a discount rate of 7%. The prorated dealer cost for the CP works out to $2,083. The company...
-
Which of the following is an expense that results from the usage of a natural resource? depletion obsolescence depreciation amortization
-
Find each product. -3a+(4 + a)
-
For each of the following linear systems, obtain a solution by graphical methods, if possible. Explain the results from a geometrical standpoint. a. x1 + 2x2 = 3, x1 x2 = 0. b. x1 + 2x2 = 3, 2x1 +...
-
Show how outputs 5 and 6 of decoder F3 in Fig. 7-7 are to be connected to the program counter PC. Fig. 7-7 FI PCTAR 3 x 8 decoder 7 6 5 4 3 210 DRTAR DRTAC ADD Select Load From PC 0 F2 Multiplexers...
-
Regarding the innovation map for an air purifier, do the following: (a) The company decides to develop a long-term strategy for the development of air purifiers. HEPA filters are used to remove solid...
-
Suppose you buy a 7 percent coupon. 20-year bond today when it's first issued. If interest rates suddenly rise to 15 percent, what happens to the value of your bond? Why?
-
Question One You must answer all parts of this question Jane runs a meeting group for parents with babies and toddlers, the "Group for Babies and Toddlers" (GBT) in the town of Glead, Ireland. She...
-
The following table summarizes the operating results for Bene Petits first year of operations: Bene Petit First year operating data: Single (1 serving) Dual (2 servings) Family (4 servings) Total...
-
Determine if the network of Figure 5 is balanced using breadth-first search starting at node B. iii) Draw the layered graph resulting from the breadth-first search among super-nodes to ex- plain your...
-
What is meant by business sustainability? Why is it good for business?
-
The piezoelectric transducers of an ultrasound machine generate frequencies of 1 0 . 5 MHz and 7 . 4 MHz . Assuming that one wavelength is the size of the smallest object that can be imaged, what is...
-
TV receives significant dividends income during the tax year. How should she report the dividends income and she has ordinary dividend income in excess of $1500
-
Tough new federal emission regulations further threaten industry profitability. What effect would the following event have on audit risk?
-
Alice Wonder owns a small candy making factory where she runs her business making custom sweets. She is planning to retire, so she has put the factory up for sale. During the time she owned the...
-
Tammy lived with her partner, Adam, for 1 5 years. They have each other listed as beneficiaries on their life insurance and 4 0 1 ( k ) accounts. They own a house together as tenants in common and a...
-
In Exercises 105108, evaluate each expression without using a calculator. log(ln e)
-
Match each of the following ratios with the formula used to compute it: -----1. Working capital -----2. Current ratio -----3. Quick ratio -----4. Accounts receivable turnover -----5. Average days to...
-
Clement Oil Corporation, which distributes gasoline products to independent gasoline stations, had $240,000 of cost of goods sold in January. The company expects a 2.5 percent increase in cost of...
-
In April 2015, McDonald's Corporation, faced with declining revenues and profits, reported that as a part of a larger restructuring plan it planned to close 700 of its company-owned restaurants by...
-
\(X\) is the number of bits in error in the next four bits transmitted. What is the expected value of the square of the number of bits in error? Now, \(h(X)=X^{2}\). Therefore, \[ \begin{aligned}...
-
Data 2.7 on page 95 introduces the dataset HollywoodMovies, which contains information on more than 900 movies that came out of Hollywood between 2007 and 2013. One of the variables is the budget (in...
-
Correlation between height and weight for players on the 2014 Brazil World Cup Team, using data from all 23 players on the roster. State whether the quantity described is a parameter or a statistic...
Study smarter with the SolutionInn App