Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to plan for the first quarter of that coming year.
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step
is to plan for the first quarter of that coming year. Northern Illinois gathered the following
information from its managers.
Sales:
Unit sates for November, prior year
Unit sales for December, prior year
Expected unit sales for January
Expected unit sales for February
Expected unit sales for March
Expected unit sales for April
Expected unit sales for May
Unit selling price $
Northern Illinois wants to keep of the next months unit sales in ending inventory. All
sales are on account. of the Accounts Receivable is collected in the month of sale and
of the Accounts Receivable is collected in the month after sale. Accounts receivable on
December totaled and this total is expected to be collected in January.
Direct Materials:
The product uses metal, plastic, and rubber. In total, each unit requires pounds of
material at an average cost of per pound.
Northern Illinois likes to keep of the materials needed for the next month in its ending
inventory. Payment for materials is made within days. is paid in the month of
purchase and is paid in the month after purchase. Accounts Payable on December
totaled $ and the total will be paid in full in January. Raw materials in inventory on
December totaled pounds.
Direct Labor:
Labor requires minutes per unit for completion and is paid at a rate of $ per hour.
Manufacturing Overhead:
Indirect materials cents per labor hour
Indirect labor cents per labor hour
Utilities cents per labor hour
Maintenance cents per labor hour
Salaries $ per month
Depreciation $ per month
Property taxes $ per month
Insurance $ per month
Janitorial $ per month
Selling and Administrative Expenses:
Variable selling and administrative cost per unit is $
Advertising $ per month
Insurance $ per month
Salaries $ per month
Depreciation $ per month
Other fixed costs $ per month
Other Information:
The cash balance on December totaled $ but management has decided that it
wants to maintain a cash balance of at least $ beginning January Dividends are
paid each month at the rate of $ per share for shares outstanding. The company
has an open line of credit with the First National Bank. The terms of the agreement requires
borrowing to be in $ increments at interest. Northern Illinois borrows on the first
day of the month and repays on the last day of the month. Reserve repayment, if required,
until the company can pay the entire amount. A $ equipment purchase is planned
for February.
Instructions Do all parts:
Note: All budgets and schedules should be prepared by month for the first quarter
January February, and March Round all figures to the nearest dollar. For labor hours
round to whole hours.
e Prepare a manufacturing overhead budget.
f Prepare a selling and administrative budget.
g Prepare a schedule for expected cash collections from customers.
h Prepare a schedule for expected payments for materials purchases.
i Prepare a cash budget.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started