Medical Essentials anticipate the following sales forecast for the months indicated. The company provides two products Antibiotics and Vaccines. Sales Forecast 2014 Details   Antibiotic   Vaccine February   5,800 units   6,400 units March   8,700 units   5,500 units April   6,275 units   7,000 units May   7,300 units   5,600 units June   8,500 units   4,250 units July   6,400 units   6,700 units Notes: I. One Antibiotic requires two (2) units of raw material fungi. One unit of fungi costs $8. Vaccines use four (4) units of raw material protein which costs $12 each. II. The company has decided that raw material stocks at the end of each month should be held equivalent to twenty percent (20%) of the budgeted sales for the next month. III. During the year, the company charged $6,000 per antibiotic and $4,000 per vaccine. IV. The decision was made that at the end of each month there should be in store sufficient finished goods stock to meet ten percent (10%) of the sales for the previous month. V. Inventory managers estimate a monthly spoilage of 25 units of antibiotics and 30 units of vaccines and a monthly deterioration of 15 units of fungi and 20 units of protein. They have suggested that a provision should be made for these items’ damages and deterioration in store.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Topic Video
Question

12. Medical Essentials anticipate the following sales forecast for the months indicated.
The company provides two products Antibiotics and Vaccines.

Sales Forecast 2014
Details   Antibiotic   Vaccine
February   5,800 units   6,400 units
March   8,700 units   5,500 units
April   6,275 units   7,000 units
May   7,300 units   5,600 units
June   8,500 units   4,250 units
July   6,400 units   6,700 units
Notes:
I. One Antibiotic requires two (2) units of raw material fungi. One unit of fungi costs $8. Vaccines use four (4) units of raw material protein which costs $12 each.

II. The company has decided that raw material stocks at the end of each month should be held equivalent to twenty percent (20%) of the budgeted sales for the next month.

III. During the year, the company charged $6,000 per antibiotic and $4,000 per vaccine.

IV. The decision was made that at the end of each month there should be in store sufficient finished goods stock to meet ten percent (10%) of the sales for the previous month.

V. Inventory managers estimate a monthly spoilage of 25 units of antibiotics and 30 units of vaccines and a monthly deterioration of 15 units of fungi and 20 units of protein. They have suggested that a provision should be made for these items’ damages and deterioration in store.

 

Required:

a) Prepare the company’s sale budget for the period April to June 2014. 

b) Prepare the production budget for both products for the period April to June 2014.

c) Prepare the direct raw materials usage budget for the period April to June 2014.

Expert Solution
steps

Step by step

Solved in 5 steps with 8 images

Blurred answer
Knowledge Booster
Accounting for Merchandise Inventory
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