Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Banks DIH Limited, wants a master budget prepared for the first quarter of 2023 The managers of the different departments have provided the following information:

Banks DIH Limited, wants a master budget prepared for the first quarter of 2023

The managers of the different departments have provided the following information: The Sales Manager has projected the following sales:

January 5,000 units

February 4,000 units

March 6,000 units

Projected selling price is $35.00/unit

Your Production Manager gave the following information:

Ending Inventory is to be 20% of next months production need to the nearest dollar

Aprils Projected Sales 5,000 units

Decembers 2022 Ending Inventory was 1,000 units

The Manufacturing Manager has estimated the following:

Each unit will require 4 grams of material

Material in Ending Inventory is 20% of next months needs

Decembers Ending Material Inventory was 4,800 g

Projected cost of material: $2.50/gram

The Personnel Manager has estimated that Direct Labour will be projected at:

0.75 hours of Direct Labour per unit

Direct Labour Cost: $8.50/hour

The Facilities Manager has estimated that the Manufacturing Overhead will be projected at:

Variable Overhead Rate to be $8 per Direct Labour hours

Fixed Overhead Rate to be $3,000 per month

The Accounting Department Manager has provided the following information:

Selling and Administrative Expenses are projected to be a monthly cost of:

Salaries $6,000

Rent $1,500

Advertising $1,100

Telephone $300

Other $500

Cash Receivable:

Decembers Sales were $10,000

80% of sales is collected in the quarter in which they were made

20% of sales collected in the following quarter in which they were made

Bad Debts is negligible

Accounts Payable:

80% of Payables is paid for in the current month

20% of Payables is paid for in the following month

Decembers Payables were $75,000

Federal Income Tax is estimated at 22% average.

Banks DIH Limited

has a $20,000 cash balance for the beginning of January

pays Dividends of $8,000 to be paid in March

pays projected Federal Income tax in March

From the beginning Balance Sheet:

Land = $150,000

Building = $45,000

Depreciation (Building) = $11,250

Retained Earnings = $58,780

Capital Stock = $225,000

For the Master Budget, you are expected to prepare the following:

Selling & Administrative Expenses Budget

Production Budget

Direct Materials Budget plus a Schedule of Expected Cash Disbursements

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

ISO 27001 Controls A Guide To Implementing And Auditing

Authors: IT Governance

1st Edition

1787781445, 978-1787781443

More Books

Students also viewed these Accounting questions

Question

Guidelines for Informative Speeches?

Answered: 1 week ago