Jack Childs is nervous about his company’s future performance. The Childs’ family owns 40% of the LLJ Satellites shares and generally controls the company’s direction. Jack is currently the CFO and a member of the Board of Directors. However, outside shareholders are becoming increasingly anxious due to poor operating results over the past few years.
Jack has hired you into the controller’s office to provide fresh perspectives about operations at LLJ Satellites. For your first assignment, Jack asks you to review the last fiscal year’s financial information and create a preliminary budgeting plan for the next fiscal year. To help you complete this assignment, Jack has provided you with various financial data relating to the previous fiscal year and a brief synopsis of the firm’s business model.
LLJ Satellites – Company Overview
LLJ Satellites makes two types of specialized transistors for satellite communication reception: an advanced and a basic device. At the beginning of each fiscal year, the company creates a projected income statement for planning purposes. Below is the budgeted income statement for the past fiscal year and standard cost information used to develop the budget.
The company uses a plant-wide pre-determined manufacturing overhead rate to apply manufacturing overhead to its products. Manufacturing overhead includes indirect manufacturing costs such as plant utilities, factory depreciation, plant maintenance, and production supervisor salaries. In essence, manufacturing overhead costs include all factory-related costs that are not direct materials or direct labor. These costs are generally estimated using a pre-determined manufacturing overhead rate based on a chosen cost driver. Budgeted manufacturing overhead is typically calculated using the following formula: Budgeted MOH = Pre-determined MOH Rate * Budgeted Cost Driver Amount. LLJ Satellites has chosen Machine Hours for its cost driver to 2
calculate budgeted manufacturing overhead. For example, the $12,845,625 of Budgeted MOH in Table 1 for the Advanced Units equals $9.75 per machine hour * 310,000 projected advanced units * 4.25 projected machine hours per advanced unit (information taken from Tables 1 and 2). Table 1: Budgeted Income Statement for Previous Fiscal Year
Revenues – Advanced (Projected Sales = 310,000 units)
$53,940,000
COGS - Advanced
Direct Materials
$18,104,000
Direct Labor
$17,670,000
Budgeted MOH
$12,845,625
Gross Margin - Advanced
$5,320,375
Revenues – Basic (Projected Sales = 360,000 units)
$48,240,000
COGS - Basic
$12,132,000
$20,520,000
$8,775,000
Gross Margin - Basic
$6,813,000
Total Gross Margin
$12,133,375
Selling Costs
Commissions (2 percent of revenues)
$2,043,600
Salaries
$460,000
Fixed Administrative Costs
$1,800,000
Interest
$550,000
Pre-Tax Income
$7,279,775
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here