Question
Introduction and Requirements: Data Computer Company manufactures hard drives for servers for all the major computer companies. Below you will find the information for
Introduction and Requirements: Data Computer Company manufactures hard drives for servers for all the major computer companies. Below you will find the information for their 2025 budget. Use the following information to create the Quarterly budgets including the full year total for the year 2025 and include the following items: Sales Budget Production Budget (Including: Direct Material, Direct Labor, Manufacturing Overhead) Operating Expenses Budget Budgeted Income Statement (Include the calculation of the cost per unit) Capital Budget Combined Cash (Including: Cash Receipts and Cash Disbursements) Budget Balance Sheet Sales Budget: Expected Unit Sales Each unit sells for $125 Data Required to Complete the Requirements Above Quarter 1 Quarter 2 Quarter 3 Quarter 4 5,000 6,000 8,000 10,000 Full Year 29,000 65% collected in quarter sold, 35% collected in following quarter. Production Budget: Ending Inventory should be 20% of the next quarter's unit sales. The expected unit sales for Quarter 1 of 2026 are 11,000 units. Direct Material Budget: Ending materials Inventory should be 10% of the next quarter's production requirements. The production of the drives requires 2.5 pounds of material costing $7 per pound The expected production requirements for Quarter 1 of 2026 is 28,050 pounds 50% of purchases are paid in quarter of purchase and the remaining 50% is paid the following quarter Direct Labor Budget: The required direct labor hours per unit are 3 hours. The average cost per direct labor hour is $20. Paid 100% in the quarter it was incurred Manufacturing Overhead Budget: Variable Costs -Calculated based on the direct labor hours used, rates are as follows: NOTE: All items are expected to be paid in the quarter in which it was incurred except for Depreciation! Indirect Material - Indirect Labor - Utilities - Fixed Cost per quarter includes: $2.00 per direct labor hour $1.30 per direct labor hour $1.20 per direct labor hour $0.50 per direct labor hour Maintenance - Supervisor Salaries - Depreciation - $30,000 Property Taxes & Insurance 4,500 (Assume this includes the New Asset Purchase. No Changes!) 15,000 Maintenance - 7,150
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