The CEO is convinced of the Director of Sales' ability to achieve a profit of $40,000...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The CEO is convinced of the Director of Sales' ability to achieve a profit of $40,000 a month and reports those costs on the company's static budget. However, actual sales for the first month were 12,900 units. The actual revenues and expenses for the month were: VARIABLE COSTS (per unit) Sales: Direct Materials: Direct Labor: Indirect Materials: Indirect Labor: Utilities for Factory: Supplies for Factory: Variable Administrative Salaries Variable Sales Commissions: FIXED COSTS (per month) Factory Supervisor Salaries: Factory Depreciation: Property Taxes (Factory): Insurance (Factory): Maintenance (Factory): Fixed Sales Salaries Depreciation, Sales Equip. Advertising $237,457 $15,200 $58,050 $1,305 $2,200 $8,900 $1,925 $9,702 $14,760 $43,000 $15,500 $4,500 $3,500 $1,860 $10,000 $12,250 $5,720 Requirement 4 (40 points) 1. Prepare a report showing the revenue and spending and activity variances for each cost, including total and net income amounts. (Remember, you will need to prepare a flexible budget for the actual level of activity in order to complete this report.) 2. Based on your report, answer the following: a. Look at the Revenue Variance in conjunction with the Selling Expense variances. What is a possible explanation for these variances? b. Are the Activity Variances mostly favorable or unfavorable? Is this a good thing? What do activity variances tell us about the company's performance? C. What do you notice about the FIXED activity variances? Why is this the case? d. What do the Direct and Indirect Materials spending variances indicate about the company's use of materials? e. What do the Direct and Indirect Labor spending variances indicate about the company's laborers? f. Overall, how well did the company perform in the first month with regard to sales of the Whack-O? Number of units Revenue Total variable costs Total fixed costs Total costs Net income FLEXIBLE BUDGET 11,700 9,200 $170,200 78,200 92,000 170,200 0 $216,450 99,450 92,000 191,450 25,000 13,200 $244,200 112,200 92,000 204,200 40,000 The CEO is convinced of the Director of Sales' ability to achieve a profit of $40,000 a month and reports those costs on the company's static budget. However, actual sales for the first month were 12,900 units. The actual revenues and expenses for the month were: VARIABLE COSTS (per unit) Sales: Direct Materials: Direct Labor: Indirect Materials: Indirect Labor: Utilities for Factory: Supplies for Factory: Variable Administrative Salaries Variable Sales Commissions: FIXED COSTS (per month) Factory Supervisor Salaries: Factory Depreciation: Property Taxes (Factory): Insurance (Factory): Maintenance (Factory): Fixed Sales Salaries Depreciation, Sales Equip. Advertising $237,457 $15,200 $58,050 $1,305 $2,200 $8,900 $1,925 $9,702 $14,760 $43,000 $15,500 $4,500 $3,500 $1,860 $10,000 $12,250 $5,720 Requirement 4 (40 points) 1. Prepare a report showing the revenue and spending and activity variances for each cost, including total and net income amounts. (Remember, you will need to prepare a flexible budget for the actual level of activity in order to complete this report.) 2. Based on your report, answer the following: a. Look at the Revenue Variance in conjunction with the Selling Expense variances. What is a possible explanation for these variances? b. Are the Activity Variances mostly favorable or unfavorable? Is this a good thing? What do activity variances tell us about the company's performance? C. What do you notice about the FIXED activity variances? Why is this the case? d. What do the Direct and Indirect Materials spending variances indicate about the company's use of materials? e. What do the Direct and Indirect Labor spending variances indicate about the company's laborers? f. Overall, how well did the company perform in the first month with regard to sales of the Whack-O? Number of units Revenue Total variable costs Total fixed costs Total costs Net income FLEXIBLE BUDGET 11,700 9,200 $170,200 78,200 92,000 170,200 0 $216,450 99,450 92,000 191,450 25,000 13,200 $244,200 112,200 92,000 204,200 40,000
Expert Answer:
Answer rating: 100% (QA)
Here is the report with the required variances and calculations Actual for month Units produced 12900 Flexible Budget for 12900 units Revenue 12900 units x 1850 per unit 238650 Direct Materials 12900 ... View the full answer
Related Book For
Managerial Accounting Tools for business decision making
ISBN: 978-1118096895
6th Edition
Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso
Posted Date:
Students also viewed these accounting questions
-
The following information was obtained from the accounting records of Macquarie Ltd. Machine A Machine B Acquisition date 1 April 2022 1 May 2022 Cost $38,000 fully paid in cash $28,800, 50% paid by...
-
Revenues Variable cost Fixed Expenses Gross profit Depreciation Net operating income Income tax expense Net income
-
For February, sales revenue is $300,000, sales commissions are 5% of sales, the sales manager's salary is $40,000, advertising expenses are $13,000, shipping expenses total 1% of sales, and...
-
Pantheon Gaming, a computer enhancement company, has three product lines: audio enhancers, video enhancers, and connection-speed accelerators. Common costs are allocated based on relative sales. A...
-
Its easier to learn accounting if you avoid real-world examples. Do you agree? Explain.
-
A $1,000 par bond with an annual coupon has only one year until maturity. Its current yield is 7.621% and its yield to maturity is 12%. What is the price of the bond?
-
Show that a value of \(\xi=0\) reduces the Halpin-Tsai equation (Equation 3.63) to the inverse rule of mixtures Equation 3.40, whereas a value \(\xi=\infty\) reduces it to the rule of mixtures...
-
The City Commission of Nashville has decided to build a botanical garden and picnic area in the heart of the city for the recreation of its citizens. The precedence table for all the activities...
-
3. [10 points] Consider the following recursive algorithm: Procedure function (double x, int y) { if x = 0, then return 0; else if y = 0, then else return 1; * return x function (x, y - 1); where y...
-
Your client, Leona Ledford, was personally served with a summons and complaint on October 23 in the case of Masters v Ledford Her answer is due in 30 days. You will mail the answer to the court. What...
-
Which of the following is a disadvantage ofdecentralization? Decision making by managers closest to the operations. Managers are able to acquire expertise in their areas ofresponsibility. Decisions...
-
What are the psychological antecedents of female arsonists?
-
The following are Hofstedes dimensions of culture, except for ___________. Power distance Femininity versus masculinity Paradoxicality Individualism versus collectivism
-
_________, __________, and __________ are three layers in Edgar Scheins organizational culture triangle. Mission, vision, values Rituals, artifacts, values Artifacts, espoused values, underlying...
-
What factors are important to deciphering the connection between drugs and crime? What are the stages that drug popularity and epidemics undergo?
-
Which style of conflict management suggests that one party is the winner and the other loser? Competition or application of force Collaboration Avoidance Compromise
-
Data for Sabanci Holding can be found in the table below. Theincome statement items correspond to revenues or costs during theyear ending in either 2018 or 2019. The balance sheet itemscorrespond t 2...
-
What is the shape of the exponential distribution?
-
Rattigan Companys income statement contained the condensed information below. Rattigans balance sheet contained the comparative data at December 31, shown below. Accounts payable pertain to operating...
-
Bracewell Company reported net income of $195,000 for 2014. Bracewell also reported depreciation expense of $40,000 and a gain of $5,000 on disposal of plant assets. The comparative balance sheet...
-
Burte Corporation prepared the following variance report. Instructions Fill in the appropriate amounts or letters for the question marks in thereport. Burte Corporation Variance Report-Purchasing...
-
Trust Management System: A university would like to develop a system for students to evaluate their peers performance in some group projects. Students ratings in various categories will affect a...
-
Building trust in potential students to join music classes by a music teacher a. Explain the above scenario. b. Draw a class diagram for it. c. Document a detailed and significant use case. d. Create...
-
Define accessibility SAP.
Study smarter with the SolutionInn App