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.75Inventory and Material Information Beginning Inventory Desired Ending Inventory Cans59,140cans62,170cansPigment 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 gallonDirect Labor and Machine Hour Information 2018 labor rate - both departments $10.25per hour Expected 2019 rate increase $0.25Per hour rate increase over 2018Production Standards and Information MagnificentMarvelous Machine hours/gallon 0.12hours0.12hours Labor hours per machine hr. 1.25hours1.25hours 2018 machines available 27 20 Annual capacity per machine 18,000gal.18,000gal. Machine hours per machine 2,000hours2,000hours Maximum annual hours per employee2,000hours2,000hours Employees per supervisor 8 8 Overhead Information 2018 Information Variable Fixed Indirect materials $0.25per gal Indirect labor rate-annual $55,000per supervisor Employee fringe benefits 25%of wages Health benefits per employee $2,000per employee Utilities $0.45per Mhr. Maintenance $0.25per Mhr.$12,000annually* Insurance $50,000annually* Property taxes $12,000annually* Supplies $6,000annually* Depreciation - mfg. $275,000annually** * These items are allocated to depts. based upon production levels in gallons. **The 2018 allocation was $150,000 for Magnificent, and $125,000 for Marvelous. It is expected that the following changes will occur in 2019: Variable Fixed Indirect materials No Change Indirect labor rate-annual 3.00%increase per employee Employee fringe benefits No Change Health benefits per employee $250increase per employee Utilities No Change Maintenance $0.05in. per Mhr.$500annual increase* Insurance $500annual increase* Property taxes 8%annual increase* Supplies $300annual increase* Depreciation - mfg. 2018 equip. No Change Depreciation - new purchases Five-year life** * These items are allocated to depts. based upon production levels in gallons. **The 2018 allocation was $150,000 for Magnificent, and $125,000 for Marvelous. 2018 Depreciation Magnificent Marvelous $150,000 $125,000 Cash Increase Debt Purchases for each new piece of equipment 5,000 $30,000Selling Department Information 2012 Information Variable Fixed Commissions $0.40per can Salaries $20,000per representative Fringe benefits 25%commissions25%salaries Health benefits $1,800per representative Advertising $10per 100 cans sold Meals & entertainment $50per week per representative Depreciation $8,000 It is expected that the following changes will occur in 2019: Variable Fixed Commissions No Change Salaries No Change Fringe benefits No Change No Changesalaries Health benefits $250increase per representative Advertising $12per 100 cans sold Meals & entertainment $60per week per representative Depreciation No Change It is expected number of sales reps. Employees during 2019 10 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

Answered: 7 8 9 0 1 2 3 4 A 9 B Year 2014 2015…

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

Direct Labor and Machine Hour Information

2018 labor rate - both departments	$10.25	per hour

Expected 2019 rate increase	$0.25	Per hour rate increase over 2018

Production Standards and Information
				Magnificent	Marvelous
	Machine hours/gallon		0.12	hours	0.12	hours
	Labor hours per machine hr.		1.25	hours	1.25	hours
	2018 machines available		27		20
	Annual capacity per machine		18,000	gal.	18,000	gal.
	Machine hours per machine		2,000	hours	2,000	hours
	Maximum annual hours per employee	2,000	hours	2,000	hours
	Employees per supervisor		8		8

Overhead Information

	2018 Information
			Variable		Fixed
	Indirect materials	$0.25	per gal
	Indirect labor rate-annual			$55,000	per supervisor
	Employee fringe benefits	25%	of wages
	Health benefits per employee			$2,000	per employee
	Utilities		$0.45	per Mhr.
	Maintenance	$0.25	per Mhr.	$12,000	annually*
	Insurance				$50,000	annually*
	Property taxes			$12,000	annually*
	Supplies				$6,000	annually*
	Depreciation - mfg.			$275,000	annually**

	* These items are allocated to depts. based upon production levels in gallons.
	**The 2018 allocation was $150,000 for Magnificent, and $125,000 for Marvelous.

	It is expected that the following changes will occur in 2019:

			Variable		Fixed
	Indirect materials	No Change
	Indirect labor rate-annual			3.00%	increase per employee
	Employee fringe benefits	No Change
	Health benefits per employee			$250	increase per employee
	Utilities		No Change
	Maintenance	$0.05	in. per Mhr.	$500	annual increase*
	Insurance				$500	annual increase*
	Property taxes			8%	annual increase*
	Supplies				$300	annual increase*
	Depreciation - mfg. 2018 equip.			No Change
	Depreciation - new purchases			Five-year life**

	* These items are allocated to depts. based upon production levels in gallons.
	**The 2018 allocation was $150,000 for Magnificent, and $125,000 for Marvelous.

	2018 Depreciation		Magnificent		Marvelous
				$150,000		$125,000

				Cash		Increase Debt
	Purchases for each new piece of equipment			5,000		$30,000

Selling Department Information

	2012 Information
		Variable		Fixed

	Commissions	$0.40	per can
	Salaries			$20,000	per representative
	Fringe benefits	25%	commissions	25%	salaries
	Health benefits			$1,800	per representative
	Advertising	$10	per 100 cans sold
	Meals & entertainment			$50	per week per representative
	Depreciation			$8,000

	It is expected that the following changes will occur in 2019:

		Variable		Fixed

	Commissions	No Change
	Salaries			No Change
	Fringe benefits	No Change		No Change	salaries
	Health benefits			$250	increase per representative
	Advertising	$12	per 100 cans sold
	Meals & entertainment			$60	per week per representative
	Depreciation			No Change

	It is expected number of sales reps. Employees during 2019	10

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

Step 1

The company should estimate its future sales. Because of the forecast sales organizations know how many units are likely to be sold in the future. There are many methods for estimating sales, such as the weighted average method, and the growth function method.

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.

7 8 9 0 1 2 3 4 A 9 B Year 2014 2015 2016 2017 2018 Totals U D Actual Sales in Gallons Weight 424,000 425,000 413,000 453,000 440,000 E -5 6 7 Marvelous Paint Volume Projection Using Growth Function 8 Known x's Known y's New x Weighted Sales F Sales Volume Projection for 2019 G H