The Volt Battery Company has forecast its sales in units as follows:       January 1,100 February 950 March 900 April 1,400 May 1,650 June 1,800 July 1,500

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter22: Master Budget (master)
Section: Chapter Questions
Problem 1R: Ranger Industries has provided the following information at June 30: Other information: Average...
icon
Related questions
Question

The Volt Battery Company has forecast its sales in units as follows:
 

   
January 1,100
February 950
March 900
April 1,400
May 1,650
June 1,800
July 1,500
 

 

Volt Battery always keeps an ending inventory equal to 130 percent of the next month’s expected sales. The ending inventory for December (January’s beginning inventory) is 1,430 units, which is consistent with this policy.
  
Materials cost $12 per unit and are paid for in the month after purchase. Labor cost is $5 per unit and is paid in the month the cost is incurred. Overhead costs are $7,500 per month. Interest of $8,300 is scheduled to be paid in March, and employee bonuses of $13,500 will be paid in June.
 

a. Prepare a monthly production schedule for January through June.

 
 
Volt Battery Company
Production Schedule
  January February March April May June July
Projected unit sales              
Desired ending inventory              
Total units required 0 0 0 0 0 0  
Beginning inventory              
Units to be produced 0 0 0 0 0 0
Expert Solution
Step 1

The manufacturing company needs materials, labor, and expenses for the production process.

Thus, the total prime cost is plays a crucial role in the estimation of sales units. Thus, the management should be organizing the high policies and transparent activities. It will helps in the growth of the company.

For better results, the company can make monthly budgets and monthly production schedule in order to achieve their targets and goals.

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Financial Reporting in Hyperinflationary Economies
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
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
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
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT