Sales in Gallons YearMagnificent Marvelous 2014424,000 None 2015425,000 None 2016413,000 226,560 2017453,000 259,000 2018440,000 295,700 Projected Selling Price for 2019 per gallon Magnificent Marvelous $14.50 $18.75 Inventory and Material Information Beginning Inventory Desired Ending Inventory Cans59,140cans62,170cans Pigment Magnificent64,300lbs.72,000 Marvelous50,400 55,700lbs. Finished Good Inv. Magnificent33,500gal.36,000gal. Marvelous25,890gal.29,000gal. 2018 Prices Cans $0.50 Super pigment $2.85per pound Stupendous pigment $3.90per pound Expected 2019 Prices Cans $0.03increase over 2018 prices Super pigment $0.15increase over 2018 prices Stupendous pigment $0.20increase over 2018 prices Usage Standards Magnificent 2lbs. per gallon Marvelous 2lbs. per gallon PLEASE SOLVE FOR BLUE BOXES ON EXCEL SHEET IN THE PICTURE PasteH24171819ABYearArialB I U20142015201620172018TotalsfxC201620172018V424,000425,000413,000453,000440,000DKnown x's Known y's New xYearStupendous YearVActual Salesin Gallons Weight Sales226,560259,600295,7002021222324252627 Marvelous Paint Volume Projection Using Growth Function28293031323334353637383940414243444546474849505152102019EWeightedProjection of Marvelous 2019 Sales VolumeA^ AAFSalesVolumeProjectionfor 2019||||||||||| |||G||||||||HM|abHIHJ

Every company has some goals, vision, and mission. There are some risks and uncertainties in…

Answered: Year 2014 2015 2016 2017 2018 Totals…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

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


Inventory and Material Information

		Beginning Inventory		Desired Ending Inventory
Cans	59,140	cans	62,170	cans
Pigment
	Magnificent	64,300	lbs.	72,000
	Marvelous	50,400		55,700	lbs.
Finished Good Inv.
	Magnificent	33,500	gal.	36,000	gal.
	Marvelous	25,890	gal.	29,000	gal.

2018 Prices
	Cans			$0.50
	Super pigment		$2.85	per pound
	Stupendous pigment		$3.90	per pound

Expected 2019 Prices
	Cans			$0.03	increase over 2018 prices
	Super pigment		$0.15	increase over 2018 prices
	Stupendous pigment		$0.20	increase over 2018 prices

Usage Standards
	Magnificent		2	lbs. per gallon
	Marvelous		2	lbs. per gallon

PLEASE SOLVE FOR BLUE BOXES ON EXCEL SHEET IN THE PICTURE

Paste
H24
17
18
19
A
B
Year
Arial
B I U
2014
2015
2016
2017
2018
Totals
fx
C
2016
2017
2018
V
424,000
425,000
413,000
453,000
440,000
D
Known x's Known y's New x
Year
Stupendous Year
V
Actual Sales
in Gallons Weight Sales
226,560
259,600
295,700
20
21
22
23
24
25
26
27 Marvelous Paint Volume Projection Using Growth Function
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
10
2019
E
Weighted
Projection of Marvelous 2019 Sales Volume
A^ A
A
F
Sales
Volume
Projection
for 2019
|||||||
|||| |||
G
||||||||
H
M
|
ab
HIH
J

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions