Sales in Gallons         Year Magnificent   Marvelous   2014 424,000   None   2015 425,000   None   2016 413,000   226,560   2017 453,000   259,000   2018 440,000   295,700   Projected Selling Price for 2019 per gallon       Magnificent   Marvelous     $14.50   $18.75 Magnificent Paint Volume Projection Using Exponential Smoothing                           Year Actual Sales in Gallons Weight Weighted Sales Sales Volume Projection for 2019   2014 424,000 1 424,000     2015 425,000 2 850,000     2016 413,000 3 1,239,000     2017 453,000 4 1,812,000     2018 440,000 5 2,200,000                 Totals   15 6,525,000 435,000                         Marvelous Paint Volume Projection Using Growth Function                 Known x's Known y's New x       Year Stupendous Year       2016 226,560 2019       2017 259,600         2018 295,700                     Projection of Marvelous 2019 Sales Volume                 338, 154

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
Sales in Gallons      
  Year Magnificent   Marvelous
  2014 424,000   None
  2015 425,000   None
  2016 413,000   226,560
  2017 453,000   259,000
  2018 440,000   295,700

 

Projected Selling Price for 2019 per gallon  
    Magnificent   Marvelous
    $14.50   $18.75
Magnificent Paint Volume Projection Using Exponential Smoothing
           
           
  Year Actual Sales in Gallons Weight Weighted Sales Sales Volume Projection for 2019
  2014 424,000 1 424,000  
  2015 425,000 2 850,000  
  2016 413,000 3 1,239,000  
  2017 453,000 4 1,812,000  
  2018 440,000 5 2,200,000  
           
  Totals   15 6,525,000 435,000
           
           
Marvelous Paint Volume Projection Using Growth Function  
           
  Known x's Known y's New x    
  Year Stupendous Year    
  2016 226,560 2019    
  2017 259,600      
  2018 295,700      
           
  Projection of Marvelous 2019 Sales Volume  
           
  338, 154        

 

E6
1234
567895
11
10 Projected Sales
12
Paste
7 Projected Sales Volume
8 Selling Price
13
14
A
15
16
Arial
B I U
fx
V
V
Magnificent
Paint
10
B
C
Paulson Paint, Inc
Sales Budget
For the Year Ended December 31, 2019
A^ A
A
D
E
Marvelous
Paint
F
|||||||
|||| |||
Total
G
||||||||
|
H
|
се
HIH
Transcribed Image Text:E6 1234 567895 11 10 Projected Sales 12 Paste 7 Projected Sales Volume 8 Selling Price 13 14 A 15 16 Arial B I U fx V V Magnificent Paint 10 B C Paulson Paint, Inc Sales Budget For the Year Ended December 31, 2019 A^ A A D E Marvelous Paint F ||||||| |||| ||| Total G |||||||| | H | се HIH
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education