Ringer Foods produces specialty soup sold in jars. The projected sales in dollars Ringer anticipates selling 221,000 jars with total sales revenue of $260,0 and jars for each quarter of the upcoming year are as follows: the first quarter of the year following the year given in the preceding table Ringer has a policy that the ending inventory of jars must be 30% of the quarter's sales. Total sales Number of jars sold revenue 1st quarter.. $ Requirement Prepare a production budget for the year that shows the number of jars produced each quarter and for the year in total. 182,000 153,500 2nd quarter 214,000 180,000 3rd quarter ..$ 252.000 4th quarter..$ 197,000 211.000 160,000 Prepare the production budget by first calculating the total units needed, then calculate the units to produce. Ringer Foods Production Budget For the Quarters in the Upcoming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Unit sales Plus: Desired ending inventory

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
100%
Ringer Foods produces specialty soup sold in jars. The projected sales in dollars Ringer anticipates selling 221,000 jars with total sales revenue of $260,000 in
and jars for each quarter of the upcoming year are as follows:
the first quarter of the year following the year given in the preceding table.
Ringer has a policy that the ending inventory of jars must be 30% of the following
quarter's sales.
Total sales
Number of jars
sold
revenue
Requirement
Prepare a production budget for the year that shows the number of jars to be
produced each quarter and for the year in total.
1st quarter .. $
182,000
153,500
2nd quarter
214,000
180,000
3rd quarter
252,000
211,000
4th quarter ..$ 197,000
160,000
Prepare the production budget by first calculating the total units needed, then calculate the units to produce.
Ringer Foods
Production Budget
For the Quarters in the Upcoming Year
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Year
Unit sales
Plus: Desired ending inventory
Total needed
Less: Beginning inventory
Units to produce
Transcribed Image Text:Ringer Foods produces specialty soup sold in jars. The projected sales in dollars Ringer anticipates selling 221,000 jars with total sales revenue of $260,000 in and jars for each quarter of the upcoming year are as follows: the first quarter of the year following the year given in the preceding table. Ringer has a policy that the ending inventory of jars must be 30% of the following quarter's sales. Total sales Number of jars sold revenue Requirement Prepare a production budget for the year that shows the number of jars to be produced each quarter and for the year in total. 1st quarter .. $ 182,000 153,500 2nd quarter 214,000 180,000 3rd quarter 252,000 211,000 4th quarter ..$ 197,000 160,000 Prepare the production budget by first calculating the total units needed, then calculate the units to produce. Ringer Foods Production Budget For the Quarters in the Upcoming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Unit sales Plus: Desired ending inventory Total needed Less: Beginning inventory Units to produce
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Forecasting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.