Sheffield Chemicals has developed a new window cleaner that requires two ingredients, AM972 and CA38. Based on forecasted sales, Sheffield has developed the following budgeted production for the coming year. 1st Quarter Next Year 3rd Quarter 9,000 1st Quarter 2nd Quarter 7,000 4th Quarter Forecasted production (gallons) 5,500 15,000 6,000 Each gallon of window cleaner requires 100 ounces of AM972 and 28 ounces of CA38. An ounce of AM972 costs Sheffield $0.20. An ounce of CA38 costs the company $0.25. Sheffield's inventory policy requires ending inventory equal to 20% of the next quarter's production needs. At the beginning of the year, Sheffield expects to have 80,000 ounces of AM972 and 30,000 ounces of CA38 on hand. Prepare Sheffield's AM972 purchases budget for the coming year. (Enter price per ounce to 2 decimal places, eg. 0.35.) 2nd Quarter 3rd Quarter 4th Quarter Annual 7000 9000 15000 36500 100 100 100 100 700,000 900000 1,500,000 3650000 900000 1,500,000 3650000 180000 300,000 120,000 740,000 -140000 -180000 i -300,000 i -730,000 740000 1020000 1320000 3660000 20 20 20 20 148000 204000 264000 732000 %24 %24 %24 %24 %24 %24 %24 %24

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

Question 5

Please fill in the blanks and explain. 

Sheffield Chemicals has developed a new window cleaner that requires two ingredients, AM972 and CA38. Based on forecasted
sales, Sheffield has developed the following budgeted production for the coming year.
1st Quarter
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Next Year
Forecasted production (gallons)
5,500
7,000
9,000
15,000
6,000
Each gallon of window cleaner requires 100 ounces of AM972 and 28 ounces of CA38. An ounce of AM972 costs Sheffield $0.20. An
ounce of CA38 costs the company $0.25. Sheffield's inventory policy requires ending inventory equal to 20% of the next quarter's
production needs. At the beginning of the year, Sheffield expects to have 80,000 ounces of AM972 and 30,000 ounces of CA38 on
hand.
Prepare Sheffield's AM972 purchases budget for the coming year. (Enter price per ounce to 2 decimal places, e.g. 0.35.)
2nd Quarter
3rd Quarter
4th Quarter
Annual
7000
9000
15000
36500
100
100
100
100
700,000
900000
1,500,000
3650000
900000
1,500,000
3650000
180000
300,000
120,000
740,000
-140000 i
-180000 i
-300,000 i
-730,000
740000
1020000
1320000
3660000
$
.20
$
20
$
20
$
20
148000
$
204000
264000
$
732000
eTextbook and Media
Attempts. 1 of 5 used
C..bmit Apguor
%24
%24
%24
%24
%24
%24
%24
Transcribed Image Text:Sheffield Chemicals has developed a new window cleaner that requires two ingredients, AM972 and CA38. Based on forecasted sales, Sheffield has developed the following budgeted production for the coming year. 1st Quarter 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Next Year Forecasted production (gallons) 5,500 7,000 9,000 15,000 6,000 Each gallon of window cleaner requires 100 ounces of AM972 and 28 ounces of CA38. An ounce of AM972 costs Sheffield $0.20. An ounce of CA38 costs the company $0.25. Sheffield's inventory policy requires ending inventory equal to 20% of the next quarter's production needs. At the beginning of the year, Sheffield expects to have 80,000 ounces of AM972 and 30,000 ounces of CA38 on hand. Prepare Sheffield's AM972 purchases budget for the coming year. (Enter price per ounce to 2 decimal places, e.g. 0.35.) 2nd Quarter 3rd Quarter 4th Quarter Annual 7000 9000 15000 36500 100 100 100 100 700,000 900000 1,500,000 3650000 900000 1,500,000 3650000 180000 300,000 120,000 740,000 -140000 i -180000 i -300,000 i -730,000 740000 1020000 1320000 3660000 $ .20 $ 20 $ 20 $ 20 148000 $ 204000 264000 $ 732000 eTextbook and Media Attempts. 1 of 5 used C..bmit Apguor %24 %24 %24 %24 %24 %24 %24
Sheffield Chemicals has developed a newwindow cleaner that requires two ingredients, AM972 and CA38. Based on forecasted
sales, Sheffield has developed the following budgeted production for the coming year.
1st Quarter
2nd Quarter
3rd Quarter
9,000
1st Quarter
4th Quarter
Next Year
Forecasted production (gallons)
5,500
7,000
15,000
6,000
Each gallon of window cleaner requires 100 ounces of AM972 and 28 ounces of CA38. An ounce of AM972 costs Sheffield $0.20. An
ounce of CA38 costs the company $0.25. Sheffield's inventory policy requires ending inventory equal to 20% of the next quarter's
production needs. At the beginning of the year, Sheffield expects to have 80,000 ounces of AM972 and 30,000 ounces of CA38 on
hand.
Prepare Sheffield's AM972 purchases budget for the coming year. (Enter price per ounce to 2 decimal places, e.g. 0.35.)
1st Quarter
2nd Quarter
3rd Quarter
Budgeted production
5500
7000
Standard price per ounce
100
100
Total DM required (ounces)
550000
700,000
900
Production needs
550000
900
Budgeted ending inventory
140000
180000
300,
Beginning inventory
-110,000
-140000 i
-180000
Budgeted purchases (ounces)
580000
740000
1020
Budgeted purchases cost
20
20
$
Budgeted production
$
116000
148000
$
204
%24
%24
%24
>
>
Transcribed Image Text:Sheffield Chemicals has developed a newwindow cleaner that requires two ingredients, AM972 and CA38. Based on forecasted sales, Sheffield has developed the following budgeted production for the coming year. 1st Quarter 2nd Quarter 3rd Quarter 9,000 1st Quarter 4th Quarter Next Year Forecasted production (gallons) 5,500 7,000 15,000 6,000 Each gallon of window cleaner requires 100 ounces of AM972 and 28 ounces of CA38. An ounce of AM972 costs Sheffield $0.20. An ounce of CA38 costs the company $0.25. Sheffield's inventory policy requires ending inventory equal to 20% of the next quarter's production needs. At the beginning of the year, Sheffield expects to have 80,000 ounces of AM972 and 30,000 ounces of CA38 on hand. Prepare Sheffield's AM972 purchases budget for the coming year. (Enter price per ounce to 2 decimal places, e.g. 0.35.) 1st Quarter 2nd Quarter 3rd Quarter Budgeted production 5500 7000 Standard price per ounce 100 100 Total DM required (ounces) 550000 700,000 900 Production needs 550000 900 Budgeted ending inventory 140000 180000 300, Beginning inventory -110,000 -140000 i -180000 Budgeted purchases (ounces) 580000 740000 1020 Budgeted purchases cost 20 20 $ Budgeted production $ 116000 148000 $ 204 %24 %24 %24 > >
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Administration and Procedures
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.
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