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...

1 answer below »








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







Direct Materials







$12,132,000







Direct Labor







$20,520,000







Budgeted MOH







$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






Answered 1 days AfterOct 26, 2022

Answer To: Jack Childs is nervous about his company’s future performance. The Childs’ family owns 40% of the...

Tanmoy answered on Oct 28 2022
54 Votes
LLJ’S SATELLITE VARIANCE ANALYSIS
Table of Contents
Memo    3
Introduction    3
Analysis    3
Suggestion for Improvements    5
Schedules for Next Fiscal Year    6
References    9
Memo
Introduction
LLJ’s Satellite company’s 40% share is owned by Jack Childs and helps in controlling the direction of the organization. Further, it is Jack Childs who is presently the Chief Financial Officer an
d a member of the company’s Board of Director. It is due to poor performance of the company’s operating results for the previous few years, the shareholders along with Jack Childs is becoming anxious. We need to prepare a memo where I will evaluate the way in which the accounting team’s variance analysis was been structured. Secondly, I will also create schedules of the budgets which are applicable for the next fiscal year. It is a budget variance which helps in analysis of the measures which are been conducted periodically and are being used by the governments, corporations, and individuals for quantifying the variances between the budgeted and the actual figures with respect to a specific accounting segment. If the variance is favourable, then it is referred as positive variances and in case the variances is unfavourable, it is a loss or a shortfall and is considered as a negative variance. Hence, there is a variance in the budget of the company which happens due to the errors of the forecasters who are unable to predict the future costs and the revenues correctly or accurately.
Analysis
Usually, the variances in budget arises due to controlled or uncontrolled factors. The controllable factors are the unplanned budgets and labour costs. On the contrary, the uncontrollable costs are external in nature and usually arises due to occurrences outside the organization in the form of natural disasters.
According to the variance analysis in Table.4 it can be observed that the company illustrates a total activity variance amounting to $1752625. There is an unfavourable activity variance with respect to the cost as there are some variable components in the cost and the actual level of activity which is much higher than the budgeted activity level (Palm Beach State, 2021). Further, activity variances result due to differences among the flexible and the static planning of the budget. These unfavourable conditions may occur due to increased orders in the form of more sales. In such situation the production manager cannot be held responsible for an unfavourable variance in the total activity.
From the Table.4 it can be observed that the revenue variance is unfavourable for advanced revenue at -$1800000 while the Basic Revenue is favourable at $2100000. Hence, from this it can be stated that the total revenue is favourable by ($2100000 - $1800000) = $300000. There is a favourable revenue variance since the actual variance exceeds the budgeted revenues of the company (Basu, 2022).
The total plastic variance which is the direct material required to produce LLJ Satellites are favourable at $405000. There is a direct material variance when there is a difference between the standard cost of materials which occurred from the manufacturing activities and the actual costs incurred. Hence, a favourable direct material cost variance occurs when there is savings available with the company and can incur costs which is lower than what is budgeted (Penn State, 2022). This means that the actual costs for manufacturing plastics is less than the anticipated costs of plastics in the budget.
On the contrary, it can be observed that the direct material aluminium variance is unfavourable for LLJ Satellites resulting in a total aluminium variance amounting to -$1936500. This happens when the actual costs are lower compared to the standard costs. From the Table.4 it can be observed that the advanced and basic...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here