Sparks Corp. manufactures knee braces and other orthopedic supplies. Knee braces sell for $175 each. Sparks Corp. projects sales for April will be 680 braces, with sales increasing by 85 braces per month for May, June and July. At the beginning of April Sparks Corp. has 135 braces on hand but desires to maintain an ending inventory of 10% of the next month's sales. Prepare the sales budget and production budget for Sparks Corp. for the months of April, May and June.

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter7: Budgeting
Section: Chapter Questions
Problem 1EA: Blue Book printing is budgeting sales of 25,000 units and already has 5,000 in beginning inventory....
icon
Related questions
Question

Sparks Corp. manufactures knee braces and other orthopedic supplies. Knee braces sell for $175 each. Sparks Corp. projects sales for April will be 680 braces, with sales increasing by 85 braces per month for May, June and July. At the beginning of April Sparks Corp. has 135 braces on hand but desires to maintain an ending inventory of 10% of the next month's sales.

Prepare the sales budget and production budget for Sparks Corp. for the months of April, May and June.

 

Sparks Corp.
Production Budget
For the Three Months Ended June 30
May
Budgeted sets to be sold
Plus: Desired units in ending inventory
Total units needed
Less: Units in beginning inventory
Budgeted units to be produced
April
680✔
77 X
757 X
135✓
622 X
765✓
85✔
850 ✓
77 X
774 X
June
850 ✓
94 X
944 X
85✔
859 X
Total
2,295✔
94 X
2,389 X
135✔
2,254 X
Transcribed Image Text:Sparks Corp. Production Budget For the Three Months Ended June 30 May Budgeted sets to be sold Plus: Desired units in ending inventory Total units needed Less: Units in beginning inventory Budgeted units to be produced April 680✔ 77 X 757 X 135✓ 622 X 765✓ 85✔ 850 ✓ 77 X 774 X June 850 ✓ 94 X 944 X 85✔ 859 X Total 2,295✔ 94 X 2,389 X 135✔ 2,254 X
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Strengths and Weaknesses
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning