# 404 Lesson 2

Satisfactory Essays
336 Words
Grammar
Plagiarism
Writing
Score
404 Lesson 2
Accounting 404
Lesson 2 Assignment: Cost Behavior
As the FallSafe Parachute Factory continues to set goals for expansion, the company needs a more accurate history of their total costs and cost behaviors over the past few months. Unfortunately, they have never relied heavily on Managerial Accounting before now, so there are large gaps of missing information that need to be calculated in order to move forward.
Directions: Each question of this assignment should be prepared as a separate sheet in one Excel file. Please change the sheet names at the bottom of the page to the question number. Then, follow the directions for each question below. Be sure to show your calculations and label your work for full credit. This assignment is worth 50 points. The grading rubric may be previewed in the Cost Behavior Drop Box.

Question 1
FallSafe began production in late 2012. The information available for October, November, and December of that year is listed below. Using the fixed and variable cost behavior formulas discussed in the Lesson 2 commentary, calculate the missing numbers.

2012 FallSafe Cost Behavior
Month
October
November
December
Number of Units Produced
2,000
2,500
3,000
Variable Costs
20,000
(e)
(k)
Fixed Costs
50,000
62,500
(l)
Total Costs
70,000
(g)
(m)
Variable Cost Per Unit
10
(h)
(n)
Fixed Cost Per Unit
25
25
25
Total Cost Per Unit
35
(j)
(p)

Question 2
Calculate this problem on sheet 2 of your Excel document. Using the High-Low Method, compute the variable cost per unit and the total fixed costs of the following FallSafe information from the preceding six months:
Month
Units Produced
Total Costs
January
3,000

\$104,000
February
5,000

\$125,000
March
2,500

\$100,000
April
4,000

\$113,500
May
4,500

\$118,000
June
4,750

\$122,000

Question 3
On sheet 3 of your Excel document, prepare a regression analysis based on the following FallSafe information from the

## You May Also Find These Documents Helpful

• Satisfactory Essays

FIN 641- Summer 2013 – Excel Assignment This assignment is due 10 am on Thursday, August 8. You need to use the Excel Template I posted. Your assignment will be graded on a scale of 0 to 25. The assignment should be submitted on Blackboard. No late assignment will be accepted. Enjoy the problems!…

• 335 Words
• 2 Pages
Satisfactory Essays
• Powerful Essays

Reconditioning the plant equipment Purchasing new equipment Outsourcing to other manufacturing operations The figures for fixed and variable costs for each section were derived from company records. I has been decided that at 1,000 units the variable costs could be determined and that it would also be a good point to set our volume at for analysis. Here is a breakdown of the costs for each option:…

• 1072 Words
• 4 Pages
Powerful Essays
• Good Essays

Chapter 4 and 5 Problems Please complete the following 7 exercises below in either Excel or a word document (but must be single document). You must show your work where appropriate (leaving the calculations within Excel cells is acceptable). Save the document, and submit it in the appropriate week using the Assignment Submission button.…

• 1284 Words
• 12 Pages
Good Essays
• Good Essays

monthly maintenance expenses submitted by each complex manager. He asks you to total the maintenance costs of each apartment complex’ for each month, and then format each worksheet. Gordon…

• 369 Words
• 2 Pages
Good Essays
• Powerful Essays

Project Hints and Guidelines It is assumed that you have access to 1. Microsoft Excel with Analysis ToolPak (do NOT use stepwise regression for this project even if it runs on your computer).…

• 1337 Words
• 6 Pages
Powerful Essays
• Satisfactory Essays

Photo for Exercise 46 Read the following instructions in order to complete this assignment, and review the example of how to complete the math required for this assignment:…

• 412 Words
• 2 Pages
Satisfactory Essays
• Good Essays

3. Use MS Excel to find the least-squares regression line for these data. Record the equation, paying attention to precision.…

• 398 Words
• 2 Pages
Good Essays
• Satisfactory Essays

• 463 Words
• 3 Pages
Satisfactory Essays
• Satisfactory Essays

Due Date: Day 4 [Individual] forum· Calculate the fixed cost, variable costs, and break-even point for the program suggested in Appendix D.·…

• 1695 Words
• 7 Pages
Satisfactory Essays
• Satisfactory Essays

First, I was expected to construct an Excel Worksheet. Using the given data and analyzing the case, I was able to find all of the fixed variables needed in the Excel Worksheet. Using these fixed variables, I was able to use my prior skills in…

• 875 Words
• 4 Pages
Satisfactory Essays
• Good Essays

Machinery 8,000 \$ 8,000 Maintenance 4,000 \$ 4,000 Energy 2,000 \$ 2,000 Total activity costs…

• 1016 Words
• 5 Pages
Good Essays
• Satisfactory Essays

| 1. I think Rachel did a great job as project manager and she managed her day very well. She arrived early to work to get an early start to the day. Even though she is clearly busy early in the day she makes enough time for her boss to discuss progress with the project. She is also a good team player because she helped Victoria get back on track perhaps by letting Victoria work with their personnel a little longer. Although it took her a while to get to it, she replied to all her emails and phone calls. Even though there was a minor obstacle that she learned about in the meeting, she stayed calm and got it resolved by contacting John and then going over to Mary's office to discuss the issue. It was a very hectic day and I believe it was a wise decision to shut the door to relax and listen to some music for a short period just to get her head back in the game. She gave everyone who wanted to talk to her all the time they needed with her and that will help everyone involved. She also stayed late to go over a few more things and go talk to her boss to fill him in with the days activities and progress. 2. The one thing it tells me for sure is that being project manager is a very hectic job. It clearly takes all that a person has to do such a difficult and fast paced job. Coming in to work early and staying at work much later than everyone else is the minimum a person can do. The project manger has many responsibilities that the rest of team doesn't, all the personnel have to do is get their task for the day and complete it, but the project manager not only has to assign these individual tasks but also manage the progress and deal with any unforeseen obstacles that may arise. The project manager has to keep everything on track and running smoothly, and Rachel has been doing a good job of it.…

• 520 Words
• 3 Pages
Satisfactory Essays
• Satisfactory Essays

Please, complete the following two applied problems in a Word or Excel document. Show all your calculations and explain your results. Submit your assignment in the drop box by using the Assignment Submission button.…

• 702 Words
• 3 Pages
Satisfactory Essays
• Good Essays

Months2009 | Production (Units) | Semi Variable Cost (Rs.) | January | 200 | 2,000…

• 2315 Words
• 10 Pages
Good Essays