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 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
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 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