View the step-by-step solution to:

Problem 5-1: Your Company, Inc. has determined that its planned production for the upcoming fiscal year is: Units to be produced; First Quarter =...

Please see attached Word Doc for questions
Problem 5-1: Your Company, Inc. has determined that its planned production for the upcoming fiscal year is: Units to be produced; First Quarter = 6,000 Second Quarter = 7,000 Third Quarter = 5,000 Fourth Quarter = 4,000 Beginning raw materials inventory for the first quarter is 2,400 pounds. Beginning accounts payable for the first quarter is $2,520. Each unit requires 4 pounds of raw material that costs $0.70 per pound. Management desires to end each quarter with an inventory equal to 10% of the following quarter’s production needs. The desired ending inventory for the fourth is 2,600 pounds. Management plans to pay 80% of the raw material purchases in the quarter acquired and 20% in the following quarter. Each unit requires 0.70 direct labor hours and the labor rate is $16.00 per hour. Required: 1] Prepare the company’s direct materials budget and schedule of expected cash disbursements for purchases of raw materials for the upcoming fiscal year. 2] Prepare the company’s direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced. Problem 5-2: My Company, Inc. has determined that its planned production for the upcoming fiscal year is: Units to be produced: First Quarter = 6,000 Second Quarter = 7,000 Third Quarter = 6,500 Fourth Quarter = 5,500 Each unit requires 1.4 direct labor hours and workers are paid $12.50 per hour. The variable manufacturing overhead rate is $0.75 per direct labor hour. The fixed manufacturing overhead is $90,000 per quarter. The only non-cash element of manufacturing overhead is depreciation, which is $20,000 per quarter. All labor costs and manufacturing overhead is paid in the quarter incurred. Required: 1] Prepare the company’s direct labor budget for the upcoming fiscal year, assuming
Background image of page 1
that the direct labor work force is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced. 2] Prepare the company’s manufacturing overhead budget. Problem 5-3: You will be required to prepare a December cash budget. You are provided with the following information: a] Cash balance on December 1 is $60,000. b] Actual sales for October and November and expected sales for December are as follows: October November December Cash sales $95,000 $105,000 $125,000 Sales on account $600,000 $785,000 $900,000 Sales on account are collected over a three month period as follows: Month of sale: 15% Month following sale: 60% Second month following sale: 20% Five percent of sales on account are uncollectible. c] Purchases of inventory for December will total $420,000. Forty percent of a month’s inventory purchases are paid in the month of purchase. The accounts payable remaining from November inventory purchases total $205,000, all of which will be paid in December. d] Selling and administrative expenses are budgeted at $440,000 for December; of this amount $50,000 is for depreciation. e] A new machine will be purchased for cash, in December, at a cost of $205,000; dividends totaling $25,000 will be paid in December. f] The company maintains a minimum cash balance of $60,000. An open line of credit is available from the company’s bank to bolster the cash position as needed. Required: 1] Prepare a schedule of cash collections for December. 2] Prepare a schedule of cash disbursements for merchandise purchases for December. 3] Prepare a cash budget for December. Indicate in the financing section any borrowing that will be needed during the month. Assume that no interest payments are due or will be paid before January.
Background image of page 2
Sign up to view the entire interaction

Top Answer

The best way to approach your question... View the full answer

8645246.xlsx

Problem 5­1
Req 1 Quarter 1
Units to be produced
x pounds of raw mat/unit
Total pounds of raw mat needed
Plus: Planned ending inventory
Total pounds of raw mat required
Less: Beginning inventory...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online