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)
-
Will p from a random sample of size 400 tend to be closer to the actual value of the population proportion when p = 0.4 or when p = 0.7? Provide an explanation for your choice.
-
After which numeral is the decimal point usually placed in scientific notation? What determines the number of numerical digits written in scientific notation?
-
1. Brockwell left his boat to be repaired at Lake Gaston Sales. The boat contained electronic equipment and other personal items. Brockwell signed a form stating that Lake Gaston had no...
-
Louisville Sports manufactures baseball bats for use by players in the major leagues. A critical requirement for elite players is that each bat they use have an identical look and feel. As a result,...
-
The Yurdone Corporation wants to set up a private cemeterybusiness. According to the CFO, Barry M. Deep, business is ??lookingup.? As a result, the cemetery project will provide a net cashinflow 2...
-
(a) A homogeneous solid body of arbitrary shape is initially at temperature T, throughout. At t = 0 it is immersed in a fluid medium of temperature T. Let L be a characteristic length in the solid....
-
Becton Labs, Incorporated, produces various chemical compoundsfor industrial use. One compound, called Fludex, is prepared usingan elaborate distilling process. The company has developed standardco 2...
-
A company has already spent $69,000 to harvest almonds, which can be sold as is for $94,500. The company can process the almonds further into butter. The additional processing would cost $691,250,...
-
Wilco Inc has the following t-accounts for the most recent period: WIP Inventory Finished Goods Inventory $5,000 $20,000 $25,000 $20,000 $75,000 $75,000 $85,000 $35,000 $10,000 $10,000 Based on the...
-
Write a Python program that will prompt the user to enter a four-digit positive integer and then print the digits one at a time, e.g.: Enter a four digit integer: 1234 1 2 3 You are NOT allowed to...
-
5- Write a C++ program (a Main function) to merge two dynamic array of characters. The user should enter the array of characters as one string. Then, the program should generate the reverse of it and...
-
How can a facial impression share what is going on with you ? what is Mood ? What are the component of emotion ? What causes happiness ? are emotions motives ?
-
The following adjusted trial balance for Bell Servicing was prepared at the end of the fiscal year, December 31, 2023: Account Debit Credit 101 Cash 7,600 119 Merchandise inventory 15,800 125...
-
In Exercises 516, find the focus and directrix of the parabola with the given equation. Then graph the parabola. y 2 = 4x
-
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...
-
1.7 Limitations of Comparative Advantage. The key to understanding most theories is what they say and what they don't. Name four or five key limitations to the theory of comparative advantage.
-
1.6 Post-LIBOR Scandal. Why do you think the UK government has resolved against the total elimina- tion of LIBOR benchmarks after the scandal?
-
1.9 Aidan's Globalization. After reading the chapter's description of Aidan's globalization process, how would you explain the distinctions between interna- tional, multinational, and global...
Study smarter with the SolutionInn App