Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

UBS company, a manufacturing business that sells baskets, wants a master budget prepared for the first three months of this year (January, February and March).

UBS company, a manufacturing business that sells baskets, wants a master budget prepared for the first three months of this year (January, February and March).

The managers of the different departments have provided the following information:

The Sales Manager has projected the following sales:

  • January 6,000 units
  • February 5,000 units
  • March 6,000 units
  • Projected selling price is $40.00/unit.

Your Production Manager gave the following information:

  • Ending Inventory is to be 20% of next months production need **rounded to the nearest 10.
  • Aprils Projected Sales 5,500 units, May 11250 units
  • December 20X5 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
  • Project 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:

o Decembers Sales were $10,000

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

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

o Bad Debts is negligible

Accounts Payable:

o 80% of Payables is paid for in the current month

o 20% of Payables is paid for in the following month

o Decembers Payables was $75,000

Federal Income Tax is estimated at 22% average.

UBS company:

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

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

o pays projected Federal Income tax in March

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

Cost of Goods Sold Budget

Selling & Administrative Expenses Budget

Production Budget

Direct Materials Budget plus a Schedule of Expected Cash Disbursements

Direct Labour Budget

Manufacturing Overhead Budget

Budgeted Income Statement plus a Budget of Collections of Accounts Receivable

Cash Budget

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

Auditing And Systems Exam Questions And Explanations

Authors: Irvin N. Gleim, William A. Hillison

13th Edition

1581945272, 978-1581945270

More Books

Students also viewed these Accounting questions

Question

4. Write goals down and regularly monitor progress.

Answered: 1 week ago