Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Package is to include the following budgets; 1. Sales budget for each quarter and for the year 2. Production budget for each quarter and for

Package is to include the following budgets;
1. Sales budget for each quarter and for the year
2. Production budget for each quarter and for the year
3. Purchasing Budget for each quarter and for the year
4. Direct labour budget for each quarter and for the year
5. Manufacturing overhead budget for each quarter and for the year
6. Selling and Administration budget
7. Work sheets for Collections and Disbursements
8. Budgeted Income Statement
9. CVP Income Statement
10. Budgeted Cash Statement
11. Budgeted Balance Sheet
Additional details:
Fine Office Company produces two products P100 and P200
Sales price per P100 is $750
Sales price per P200 is $820
There are 800 units from P100 in finished goods inventory at the end of 2020 with a value of $ units from P200 at the end
of 2020 value 3,00,000 . At the end of each quarter, Fine Office Company requires ending inventory to be equal to
The required ending inventory for Dec. 31, 2021 are 600 units for P100 and
Each P100 unit uses 75 sq. ft. of steel during the manufacturing process. The cost of steel for 2021 is estimated to be $
Each P200 unit uses 95 sq. ft. of steel during the manufacturing process.
Fine Office Company currently has 30,000 sq. ft. of steel in the beginning inventory. At
the end of each quarter, Fine Office Company wants to have 60,000
inventory.
Each product requires 6 machine hours and 3 direct labour hrs to produce.
Direct Labour costs $ 21 per direct labour hour.
Fine Office Company allocates manufacturing overhead costs based on the estimated machine
hours. Estimated manufacturing overhead cost for 2021 are $ 9,45,000
For each quarter, it is estimated that 40 % of sales will be cash and
% will be credit sales. Of the credit sales, 80% pay in the quarter of the sale and 20% pay in the
following quarter. Credit sales from Q4 2020 were $13,00,000
Direct labour costs and manufacturing overhead costs are paid for in cash in the quarter they
occurred.
Assume operating expenses occur evenly throughout the year and are all paid in cash.
For each quarter, 70 % of material purchases are paid for in cash in the quarter of
the purchase and 30 % are paid in the following quarter. Purchases of materials from
Q4 2020 were $15,00,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting A Practical Approach Chapters 1-26

Authors: Jeffrey Slater

8th Edition

0130911429, 978-0130911421

More Books

Students also viewed these Accounting questions