2 3 4 5 6 Sales 7 Espresso 8 Drip Coffee 9 Food/Beverage 10 Merchandise 11 Computer 12 Total Sales 13 Expenses 14 15 16 Payroll 17 Internet 18 Building 19 20 21 22 23 Income 24 Net Income 25 Profit Margin 26 Cost of Goods Cost of Merchandise Advertising Capital Assets Miscellaneous Total Exp 27 Student's Name: K‹ First Q $ $ $ $ $ $ $ S $ Downtown Internet Café First Quarter Forecast JAN FEB 26,400 $ 27,200 $ 26,500 $ 14,400 $ 14,500 $ 14,800 $ 11,100 $ $10,800 $ 11,000 4,400 $ 5,300 $ 4,500 $ 1,050 $ 1,165 $ 1,245 $ 58,250 $ 58,265 $ 57,845 $ $ $ $ $ $ 1,300 $ MAR 17,580 $ 3,710 $ 12,000 $ 12,000 325 $ 325 $ 2,100 $ 2,100 $ 600 $ 600 $ 1,500 $ 1,500 $ 1,300 $ 17,750 $ 17,545 $ 3,080 $ 3,150 $ $12,000 $ 325 $ 2,100 $ 600 $ 1,500 $ 1,300 $ $ 58,250 $ 58,265 $ 57,845 $ TOTAL First Q Goal Seek Minivan Loan P AVG 80,100 $26,700 43,700 $14,567 32,900 $10,967 14,200 $4,733 3,460 $ 1,153 174,360 $58,120 52,875 $17,625 9,940 $3,313 36,000 $12,000 325 975 $ 6,300 $2,100 1,800 $ 600 4,500 $1,500 3,900 $1,300 174,360 $58,120 Proportion Proportion shows the ratio (%) of each sales item over the Total Sales. Add Net Income Sparkline for the months of Jan. to Mar. in Cell H24.
2 3 4 5 6 Sales 7 Espresso 8 Drip Coffee 9 Food/Beverage 10 Merchandise 11 Computer 12 Total Sales 13 Expenses 14 15 16 Payroll 17 Internet 18 Building 19 20 21 22 23 Income 24 Net Income 25 Profit Margin 26 Cost of Goods Cost of Merchandise Advertising Capital Assets Miscellaneous Total Exp 27 Student's Name: K‹ First Q $ $ $ $ $ $ $ S $ Downtown Internet Café First Quarter Forecast JAN FEB 26,400 $ 27,200 $ 26,500 $ 14,400 $ 14,500 $ 14,800 $ 11,100 $ $10,800 $ 11,000 4,400 $ 5,300 $ 4,500 $ 1,050 $ 1,165 $ 1,245 $ 58,250 $ 58,265 $ 57,845 $ $ $ $ $ $ 1,300 $ MAR 17,580 $ 3,710 $ 12,000 $ 12,000 325 $ 325 $ 2,100 $ 2,100 $ 600 $ 600 $ 1,500 $ 1,500 $ 1,300 $ 17,750 $ 17,545 $ 3,080 $ 3,150 $ $12,000 $ 325 $ 2,100 $ 600 $ 1,500 $ 1,300 $ $ 58,250 $ 58,265 $ 57,845 $ TOTAL First Q Goal Seek Minivan Loan P AVG 80,100 $26,700 43,700 $14,567 32,900 $10,967 14,200 $4,733 3,460 $ 1,153 174,360 $58,120 52,875 $17,625 9,940 $3,313 36,000 $12,000 325 975 $ 6,300 $2,100 1,800 $ 600 4,500 $1,500 3,900 $1,300 174,360 $58,120 Proportion Proportion shows the ratio (%) of each sales item over the Total Sales. Add Net Income Sparkline for the months of Jan. to Mar. in Cell H24.
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter22: Master Budget (master)
Section: Chapter Questions
Problem 2R: Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas...
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
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.Recommended textbooks for you
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning