Click the icon to view the estimated expenses for the last nine months of the coming year. Define range names for each month and type of expense. Which are reasonable range names to give each month? A. Apr, May, Jun, Jul, Aug. Sept, Oct, Nov, Dec OB. Cost of Goods, Advert, Salaries, Supplies, Misc OC. Apr May Jun Jul Aug Sept, Oct Nov Dec OD. Cost, Advert, Salaries, Supplies, Misc Which are reasonable range names to give each type of expense? OA. Cost of Goods, Advert, Salaries, Supplies, Misc OB. Apr, May, Jun, Jul, Aug. Sept, Oct, Nov, Dec C. Cost, Advert, Salaries, Supplies, Misc OD. Apr May Jun Jul Aug Sept, Oct Nov Dec Use the range names in formulas to find the total for each month. Fill in the total for each month below. (Simplify your answers.) A 1 Expenses 2 Cost of Goods 3 Advertising 4 Salaries for the last B April $2,550 $2.500 $18,650 5 Supplies $1,300 6 Miscellaneous $15,000 7Total for Each $ Month с С May $2.880 $2,500 D G H July $3,170 F August September October November December $3,230 $3,900 $2,840 $2,600 $2,280 $3.000 $3.000 $2.500 $1.500 $1,500 $1,500 $30,000 $30,000 $30,000 $18,850 $18,850 $1,360 $1,440 $1,550 $1,550 $1,500 $1,450 $15,000 $15,400 $15,800 $16,500 $16,000 $15,300 $18,650 $18,650 $1,300 $14,200 $0 $ nes for E June $2,950 $2.500 $18,850 $1,400 $15,000 range names in o ulas to ma ne total for each Budget Forcast (Estimated Expenses) Expenses April May June July August Cost of Goods $2,550 $2,880 $2,950 $3,170 $3,230 Advertising $2,500 $2,500 $2,500 $3,000 $3,000 Salaries $18,650 $18,650 $18,650 $30,000 $30,000 Supplies $1,300 $1,360 $1,440 $1,550 $1,550 Miscellaneous $15,000 $15,000 $15,400 $15,800 $16,500 Print type of September October November December $3,900 $2,840 $2,600 $2,280 $2,500 $1,500 $1,500 $1,500 $30,000 $18,850 $18,850 $18,850 $1,500 $1,450 $1,400 $1,300 $16,000 $15,300 $15,000 $14,200 Done
Click the icon to view the estimated expenses for the last nine months of the coming year. Define range names for each month and type of expense. Which are reasonable range names to give each month? A. Apr, May, Jun, Jul, Aug. Sept, Oct, Nov, Dec OB. Cost of Goods, Advert, Salaries, Supplies, Misc OC. Apr May Jun Jul Aug Sept, Oct Nov Dec OD. Cost, Advert, Salaries, Supplies, Misc Which are reasonable range names to give each type of expense? OA. Cost of Goods, Advert, Salaries, Supplies, Misc OB. Apr, May, Jun, Jul, Aug. Sept, Oct, Nov, Dec C. Cost, Advert, Salaries, Supplies, Misc OD. Apr May Jun Jul Aug Sept, Oct Nov Dec Use the range names in formulas to find the total for each month. Fill in the total for each month below. (Simplify your answers.) A 1 Expenses 2 Cost of Goods 3 Advertising 4 Salaries for the last B April $2,550 $2.500 $18,650 5 Supplies $1,300 6 Miscellaneous $15,000 7Total for Each $ Month с С May $2.880 $2,500 D G H July $3,170 F August September October November December $3,230 $3,900 $2,840 $2,600 $2,280 $3.000 $3.000 $2.500 $1.500 $1,500 $1,500 $30,000 $30,000 $30,000 $18,850 $18,850 $1,360 $1,440 $1,550 $1,550 $1,500 $1,450 $15,000 $15,400 $15,800 $16,500 $16,000 $15,300 $18,650 $18,650 $1,300 $14,200 $0 $ nes for E June $2,950 $2.500 $18,850 $1,400 $15,000 range names in o ulas to ma ne total for each Budget Forcast (Estimated Expenses) Expenses April May June July August Cost of Goods $2,550 $2,880 $2,950 $3,170 $3,230 Advertising $2,500 $2,500 $2,500 $3,000 $3,000 Salaries $18,650 $18,650 $18,650 $30,000 $30,000 Supplies $1,300 $1,360 $1,440 $1,550 $1,550 Miscellaneous $15,000 $15,000 $15,400 $15,800 $16,500 Print type of September October November December $3,900 $2,840 $2,600 $2,280 $2,500 $1,500 $1,500 $1,500 $30,000 $18,850 $18,850 $18,850 $1,500 $1,450 $1,400 $1,300 $16,000 $15,300 $15,000 $14,200 Done
Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter8: Time Series Analysis And_forecasting
Section: Chapter Questions
Problem 2P: Refer to the time series data in Problem 1. Using the average of all the historical data as a...
Related questions
Concept explainers
Question
Please assist with question 3
Transcribed Image Text:The database shows estimated expenses for the last nine months of the coming year. Define range names for each month and type of expense and use the range names in formulas to find the total for each month and type of expense.
Click the icon to view the estimated expenses for the last nine months of the coming year.
Define range names for each month and type of expense. Which are reasonable range names to give each month?
A. Apr, May, Jun, Jul, Aug, Sept, Oct, Nov, Dec
O B. Cost of Goods, Advert, Salaries, Supplies, Misc
O C. Apr_May_Jun, Jul_Aug_Sept, Oct Nov Dec
O D. Cost, Advert, Salaries, Supplies, Misc
Which are reasonable range names to give each type of expense?
O A.
Cost of Goods, Advert, Salaries, Supplies, Misc
O B.
Apr, May, Jun, Jul, Aug, Sept, Oct, Nov, Dec
C.
Cost, Advert, Salaries, Supplies, Misc
O D. Apr_May_Jun, Jul Aug Sept, Oct Nov Dec
Use the range names in formulas to find the total for each month. Fill in the total for each month below.
(Simplify your answers.)
A
B
April
1 Expenses
2 Cost of Goods $2,550
3 Advertising $2,500
4 Salaries
$18,650
5 Supplies
$1,300
6 Miscellaneous $15,000
Total for Each
7
Month
с
May
$2,880
$2,500
$18,650
$1,360
$15.000
$
D
E
June
$2,950
July
$3,170
$3,000
$2,500
$18,650 $30,000 $30,000
$1,440
$15,400
$1,550
$15,800
$1,550
$16,500
$
$
$
G
H
F
August September October
$3,230 $3,900
$3,000
$2,840
$1,500
$2,500
$30,000 $18,850
$1,500
$16,000
$1,450
$15.300
$
$
$2,600
$1,500
$18,850
C
$1,400
$15,000
$
Budget Forcast (Estimated Expenses)
November December
$2,280
$1,500
$18,850
$1,300
$14,200
$
Expenses April
Cost of Goods $2,550
Advertising $2,500
Salaries
May
June July
$2,880 $2,950 $3,170
$2,500 $2,500 $3,000
$18,650 $18,650 $18,650 $30,000
Supplies $1,300 $1,360 $1,440 $1,550
Miscellaneous $15,000 $15,000 $15,400 $15,800
Print
September October
$3,900 $2,840
$2,500 $1,500
August
November December
$3,230
$2,600 $2,280
$3,000
$1,500 $1,500
$30,000 $30,000 $18,850 $18,850 $18,850
$1,550 $1,500
$1,450
$1,400 $1,300
$16,500 $16,000 $15,300 $15,000 $14,200
Done
D
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 3 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 Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning