TOTAL Year 1 Sales Budget Hot Beverages Cald Beverages JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC 12,400 14,000 17,360 18,000 18,600 18.000 17,360 24.800 18,600 18.000 21,700 23,560 24,000 9.000 228,380 3,100 3,528 4,350 4,500 9.300 10,500 15.750 15,750 10,850 9.300 113,928 Food items 3,000 3,720 4.340 9,000 9,300 9,000 8,680 10,540 11,400 11,780 13,200 16,120 110,080 Caffee and Tea - bulk 1,116 1.260 1,674 1,755 1,953 2,295 2,511 2,650 2,700 2,930 3,105 3,348 27,297 Gift Cards 310 560 620 600 1,240 750 775 775 900 900 1,600 2,100 11,130 Gross Sales 19,926 23,068 28,344 33,855 40,393 40,545 45,076 50,565 52,450 50,020 50,905 55,668 490.815 Less: Returns & Allowances Net Sales 19,926 23,068 28,344 33,855 40,393 40,545 45.076 50,565 52,450 50,020 50,905 55,668 490,815 Other Income Total Income 19,926 23,068 28,344 33,855 40,393 40,545 45.076 50,565 52,450 50.020 50,905 55,668 490,815 Credit Management Sales (cash) 19,926 23.048 28,344 33,855 40,393 40,545 45,076 50,565 52,450 50,020 50,905 55,668 490,815 Sales (credit) Bad Debt Experse - Accrual Received on Account Bad Debt - Cash Flow Assumptions- Year 1 Hot Beverages Cald Beverages Coffee, latte, cappuccino, chai tea Average price $4 Soft drinks, juice, water, tea, frozen coffee drinks Average price $2 Food items Pastries, bagels, desserts Average price $4 for individualS 15 for whole desserts Coffee by the pound; tea bags and loose tea Average price $9 per pound Caffee and Tea - bulk Git Cards Available in any amount Less: Returns & Allowances Other Income Sales (canh) Sales (credit) Bad Debt Experse - Accrual Received on Account Bad Debt - Cash Flow YEAR 1 YEAR 1 YE AR 1 YEAR YE AR 1 YE AR 1 YE AR 1
TOTAL Year 1 Sales Budget Hot Beverages Cald Beverages JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC 12,400 14,000 17,360 18,000 18,600 18.000 17,360 24.800 18,600 18.000 21,700 23,560 24,000 9.000 228,380 3,100 3,528 4,350 4,500 9.300 10,500 15.750 15,750 10,850 9.300 113,928 Food items 3,000 3,720 4.340 9,000 9,300 9,000 8,680 10,540 11,400 11,780 13,200 16,120 110,080 Caffee and Tea - bulk 1,116 1.260 1,674 1,755 1,953 2,295 2,511 2,650 2,700 2,930 3,105 3,348 27,297 Gift Cards 310 560 620 600 1,240 750 775 775 900 900 1,600 2,100 11,130 Gross Sales 19,926 23,068 28,344 33,855 40,393 40,545 45,076 50,565 52,450 50,020 50,905 55,668 490.815 Less: Returns & Allowances Net Sales 19,926 23,068 28,344 33,855 40,393 40,545 45.076 50,565 52,450 50,020 50,905 55,668 490,815 Other Income Total Income 19,926 23,068 28,344 33,855 40,393 40,545 45.076 50,565 52,450 50.020 50,905 55,668 490,815 Credit Management Sales (cash) 19,926 23.048 28,344 33,855 40,393 40,545 45,076 50,565 52,450 50,020 50,905 55,668 490,815 Sales (credit) Bad Debt Experse - Accrual Received on Account Bad Debt - Cash Flow Assumptions- Year 1 Hot Beverages Cald Beverages Coffee, latte, cappuccino, chai tea Average price $4 Soft drinks, juice, water, tea, frozen coffee drinks Average price $2 Food items Pastries, bagels, desserts Average price $4 for individualS 15 for whole desserts Coffee by the pound; tea bags and loose tea Average price $9 per pound Caffee and Tea - bulk Git Cards Available in any amount Less: Returns & Allowances Other Income Sales (canh) Sales (credit) Bad Debt Experse - Accrual Received on Account Bad Debt - Cash Flow YEAR 1 YEAR 1 YE AR 1 YEAR YE AR 1 YE AR 1 YE AR 1
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Concept explainers
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Question
- Assuming that the average customer ticket is $6, determine:
Number of customers per day the first month they are open (January) __________
Number of customers per day the 6th month they are open (June) __________
Number of customers per day the 12th month they are open (December)________
Transcribed Image Text:TOTAL
Year 1
Sales Budget
Hot Beverages
Cald Beverages
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
12,400
14,000
17,360
18,000
18,600
18.000
17,360
24.800
18,600
18.000
21,700
23,560
24,000
9.000
228,380
3,100
3,528
4,350
4,500
9.300
10,500
15.750
15,750
10,850
9.300
113,928
Food items
3,000
3,720
4.340
9,000
9,300
9,000
8,680
10,540
11,400
11,780
13,200
16,120
110,080
Caffee and Tea - bulk
1,116
1.260
1,674
1,755
1,953
2,295
2,511
2,650
2,700
2,930
3,105
3,348
27,297
Gift Cards
310
560
620
600
1,240
750
775
775
900
900
1,600
2,100
11,130
Gross Sales
19,926
23,068
28,344
33,855
40,393
40,545
45,076
50,565
52,450
50,020
50,905
55,668
490.815
Less: Returns & Allowances
Net Sales
19,926
23,068
28,344
33,855
40,393
40,545
45.076
50,565
52,450
50,020
50,905
55,668
490,815
Other Income
Total Income
19,926
23,068
28,344
33,855
40,393
40,545
45.076
50,565
52,450
50.020
50,905
55,668
490,815
Credit Management
Sales (cash)
19,926
23.048
28,344
33,855
40,393
40,545
45,076
50,565
52,450
50,020
50,905
55,668
490,815
Sales (credit)
Bad Debt Experse - Accrual
Received on Account
Bad Debt - Cash Flow
Assumptions- Year 1
Hot Beverages
Cald Beverages
Coffee, latte, cappuccino, chai tea Average price $4
Soft drinks, juice, water, tea, frozen coffee drinks Average price $2
Food items
Pastries, bagels, desserts Average price $4 for individualS 15 for whole desserts
Coffee by the pound; tea bags and loose tea Average price $9 per pound
Caffee and Tea - bulk
Git Cards
Available in any amount
Less: Returns & Allowances
Other Income
Sales (canh)
Sales (credit)
Bad Debt Experse - Accrual
Received on Account
Bad Debt - Cash Flow
YEAR 1 YEAR 1 YE AR 1 YEAR
YE AR 1 YE AR 1 YE AR 1
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 4 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education