5 Pages

M3CaseSpreadsheetVanNorman

Course: MBAA 517, Spring 2010
School: Embry-Riddle FL/AZ
Rating:
 
 
 
 
 

Word Count: 248

Document Preview

CHAMPLAIN LAKE SPORTING GOODS COMPANY Budgeted Income Statement For the Year Ended December 31, 20x4 Sales Cost of Goods Sold Gross Margin $15,000,000 $9,000,000 $6,000,000 Selling and Administrative Expenses: Commisions $3,000,000 All other expenses (fixed) $150,000 Income before taxes Income tax (30%) $3,150,000 $2,850,000 $855,000 Net Income $1,995,000 Module 3 1. Compute Lake Champlain Sporting Goods...

Register Now

Unformatted Document Excerpt

Coursehero >> Florida >> Embry-Riddle FL/AZ >> MBAA 517

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
CHAMPLAIN LAKE SPORTING GOODS COMPANY Budgeted Income Statement For the Year Ended December 31, 20x4 Sales Cost of Goods Sold Gross Margin $15,000,000 $9,000,000 $6,000,000 Selling and Administrative Expenses: Commisions $3,000,000 All other expenses (fixed) $150,000 Income before taxes Income tax (30%) $3,150,000 $2,850,000 $855,000 Net Income $1,995,000 Module 3 1. Compute Lake Champlain Sporting Goods estimated breakeven point in sales dollars for the year ending December 31, 20x4, based on the budgeted income statement prepared by the controller. Contribution-margin ratio 0.2 Break-even point = fixed expenses $750,000 Contribution-margin ratio $150,000 0.2 Module 3 2. Compute the estimated break- even point in sales dollars for the year ending December 31, 20x4, if the company employs its own sales personnel. Fixed Expenses Previous Expenses New Salaries Total Fixed Expenses New Contribution Margin-Ratio Gross Margin Commissions Contribution Margin-Ratio Break-Even Point $150,000 $375,000 $525,000 $6,000,000 $750,000 0.35 $1,500,000 Module Compute 3 3. the estimated volume in sales dollars that would be required for the year ending Decem-ber 31, 20x4, to yield the same net income as projected in the budgeted income statement, if management continues to use the independent sales agents and agrees to their demand for a 25 percent sales commission. New Contribution Margin-Ratio Gross Margin Commissions $6,000,000 $3,750,000 Contribution Margin-Ratio Sales volume in dollars required to earn after-tax net income 0.15 $20,000,000 Module 3 4. Compute the estimated volume in sales dollars that would generate an identical net income for the year ending December 31, 20x4, regardless of whether Lake Champlain Sporting Goods Company employs its own sales personnel or continues to use the independent sales agents and pays them a 25 percent commission. x=volume of sales solve variable/fixed cost equation 0.35*x-525000=0.15*x-150000 0.2*x=375000 Identical net income amount $1,875,000
Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

Embry-Riddle FL/AZ - MBAA - 517
Income statement w/ absorption-costingY1Y2Sales Rev$62,500 $62,500Cost of goods sold$26,250 $33,250Gross Margin$36,250 $29,250Selling/Admin Exp$22,500 $22,500Op Income$13,750$6,750Income statement w/ Variable-costingY1Y2Sales Rev$62,500
Embry-Riddle FL/AZ - MBAA - 517
Jay Rexford, president of Photo Artistry Company, was just concluding a budget meeting withhis senior staff. It was November of 20x4, and the group was discussing preparation of the firmsmaster budget for 20x5. Ive decided to go ahead and purchase the i
Embry-Riddle FL/AZ - MBAA - 517
S frame unit salesS sales priceS frame sales revenueL frame unit salesL sales priceL frame sales revenueTotal sales revenueCash SalesSales on Account20x4 4th Qtr 20x5 1st Qtr 20x5 2nd Qtr 20x5 3rd Qtr 20x5 4th QtrEntire Year50000550006000065
Embry-Riddle FL/AZ - MBAA - 517
February Flexible budgetUnits (lbs)RevenueDirect MaterialDirect LaborVariable overheadTotal variable costsContribution marginFlexible Budget ActualVariance225000 225000$1,800,000 1777500326250 432500189000 174000364500 375000$879,750981500
Embry-Riddle FL/AZ - MBAA - 517
IDI NPV AnalysisNew EquipWorking CapitalEquip DispositionOld fork liftsNew Conveyor BeltOperating RevenueOperating SavingsTax EffectsTot Cash Flows12% DiscountPVNPVTime = 0Time = 1$(4,500,000)$(1,000,000)Time = 2Time = 3Time = 4Time =
Embry-Riddle FL/AZ - MBAA - 517
EOQ = sqrt([2*annual requirment*cost per order]/[annualholding cost per unit])Case ACase BCase C105082401. Lead time1 monthSafety stock = difference in average monthly usage and maximum usage in a monthAverage monthly usage65Maximum usage80
Embry-Riddle FL/AZ - MBAA - 517
M9 Case StudyMichael Van NormanMBAA 517The course text defines an internal control as broadly defined as a process, establishedby entitys board of directors, management, and other personnel, designed to provide reasonableassurance regarding the achie
Embry-Riddle FL/AZ - MBAA - 517
ACCOUNTING TOOLS APPLIED TO THE USPSAccounting Tools Applied to the USPSMichael Van NormanEmbry Riddle Aeronautical University1ACCOUNTING TOOLS APPLIED TO THE USPSAbstractThe United States Postal Service is a premier mail delivery company. The mana
Keller Graduate School of Management - ACC - 505
Case Study 2Springfield Express is a luxury passenger carrier in Texas. All seats are first class, and thefollowing data are available:Number of seats per passenger train car90Average load factor (percentage of seats filled)70%Average full passenge
Alexandria University - EE - 111
CHAPTER 8UNSYMMETRICAL FAULTSThe sequence circuits and the sequence networks developed in the previous chapterwill now be used for finding out fault current during unsymmetrical faults. Specifically weare going to discuss the following three types of
Albany Technical College - CHEM - 101
: ) (: : , h, k , l . h, k , l , u, v, w VatomVunit cell. u, v, w : h, k , l . . ) (x,y,z :) ( :Bravais Lattices1 0 x, y, z0 09;b c0 090 090021;b c(P,I,F) Cubic : a(P,I) Tetragonal : a
Hampton - BIO - 101
We are becoming increasingly dependent on computers. Can you be more specific when you say"we" I assume you mean Americans, but I am not sure. Not every part of the world has thistechnology yet.Computerization is a new trend which is very controversial
Universitas Padjadjaran - ACCT - 111
ESTABLISHINGSTRATEGIC PAY PLANSCompensationBASIC FACTORS IN DETERMINING PAYRATESEmployee compensation is all forms of pay going toemployee and arising from their employmentIt has 2 components: Direct financial payments (wages, salaries, incentives
Ashford University - SOC - 101
Research PaperJennifer Marie HudnallSOC 101 Introduction to SociologyInstructor: Diane MezaMay 28, 2012Education is very important, and at some point of time it is a part of everyone'slife. Education is something that we begin to be apart of from th
DePaul - ART - 120
Daniel TolandDiscussion Week 1Describe the work of the Paleolithic culture.Prehistoric people often represented their world- and perhaps their beliefs- throughvisual images. Art emerged with the appearance and dispersion of fully modern peoplethrough
DePaul - ART - 120
ART 120Week 2What are the differences and similarities between representational and non-representationalarts?The word "representational," when used to describe a work of art, means that the workdepicts something easily recognized by most people.For
DePaul - ART - 120
ART 120Week 3What is Photorealism and when did it emerge?Photorealism is the genre of painting based on making a painting from the use of aphotograph. The term is primarily applied to paintings from the United States artmovement that began in the lat
DePaul - ART - 120
ART 120 week 4Discuss why Michelangelos David is considered a very special work.David is a masterpiece of Renaissance sculpture sculpted by Michelangelo from 1501 to1504. The 5.17 meter (17 ft) marble statue portrays the Biblical King David in the nude
DePaul - ART - 120
ART 120 week 5Discuss how line can affect either the dynamic or static nature of a composition.Line art is any image that consists of distinct straight and curved lines placed against a(usually plain) background, without gradations in shade (darkness)
DePaul - ART - 120
ART 120 week 6Discuss figure-ground in art and provide an example.Figure-ground organization is probably best known by the faces-vase drawing that Rubindescribed. This drawing exemplifies one of the key aspects of figure-groundorganization, edge-assig
DePaul - ART - 120
ART 120 week 7Discuss how the theories of Josef Albers have contributed to understandings on color.Albers was a teacher in the Bauhaus, a school that changed how art was taught. He taughtthat interpretation of any color depends on its environment. His
DePaul - ART - 120
ART 120 week 8Discuss Op Art as a movement and explain the major principle of the movement and thekey artists and their artwork.Op art, also known as optical art, is a genre of visual art that makes use of opticalillusions."Optical art is a method of
DePaul - ART - 120
ART 120 week 10Renaissance art showed anatomy explore this concept and discuss what made aRenaissance Artist.Italian Renaissance artists became anatomists by necessity, as they attempted to refine amore lifelike, sculptural portrayal of the human figu
DePaul - ART - 120
ART 120 week 12Compare two periods of fine art that include painting and discuss the work of two keyartists.SurrealismSurrealism is a cultural movement that began in the early 1920s, and is best known forthe visual artworks and writings of the group
DePaul - ART - 120
ART 120 week 13Discuss the forms of sculpture that cross boundaries between arts suchEvents and Happenings.A happening is a performance, event or situation meant to be considered as an art.Happenings take place anywhere (from basements to studio lofts
DePaul - ART - 120
Using math to find projectile trajectoriesDaniel TolandPre-calculus5/7/2009In order to find the trajectories of a projectile you must first understand some basicconcepts about a projectile. A projectile is an object upon which the only force acting i
DePaul - ENG - 120
DePaul - ENG - 120
Problem 19.1 The moment of inertia of the rotor ofthe medical centrifuge is I = 0.2 kg-m2 . The rotor startsfrom rest and the motor exerts a constant torque of0.8 N-m on it.(a)How much work has the motor done on the rotorwhen the rotor has rotated t
DePaul - ENG - 120
Problem 12.1 The value of is 3.1415962654. . . . . IfC is the circumference of a circle and r is its radius,determine the value of r/C to four signicant digits.Solution:C = 2 r 1r== 0.159154943.C2To four signicant digits we haveProblem 12.2 Th
DePaul - ENG - 120
Problem 13.1 In Example 13.2, suppose that the vehicle is dropped from a height h = 6m. (a) What is thedownward velocity 1 s after it is released? (b) What isits downward velocity just before it reaches the ground?Solution: The equations that govern th
DePaul - ENG - 120
Problem 14.1 In Active Example 14.1, suppose thatthe coefcient of kinetic friction between the crate andthe inclined surface is k = 0.12. Determine the distance the crate has moved down the inclined surface att = 1 s.20Solution: There are three unkno
DePaul - ENG - 120
Problem 15.1 In Active Example 15.1, what is thevelocity of the container when it has reached the positions = 2 m?AsSolution: The 180-kg container A starts from rest at s = 0. Thehorizontal force (in newtons) is F = 700 150s . The coefcient ofkinet
DePaul - ENG - 120
Problem 16.1 The 20-kg crate is stationary at timet = 0. It is subjected to a horizontal force given as afunction of time (in newtons) by F = 10 + 2t 2 .F(a)Determine the magnitude of the linear impulseexerted on the crate from t = 0 to t = 4 s.(b)
DePaul - ENG - 120
Problem 17.1 In Active Example 17.1, suppose thatat a given instant the hook H is moving downward at2 m/s. What is the angular velocity of gear A at thatinstant?200 mm50 mmBA100mmSolution: The angular velocity of gear B isvH2 m/s== 20 rad/s.
DePaul - ENG - 120
Problem 18.1 A horizontal force F = 133.4 N is appliedto the 1023 N refrigerator as shown. Friction is negligible.(a)(b)What is the magnitude of the refrigerators acceleration?What normal forces are exerted on the refrigeratorby the oor at A and B ?
DePaul - ENG - 120
DePaul - ENG - 120
DePaul - ENG - 120
DePaul - ENG - 120
DePaul - ENG - 120
DePaul - ENG - 120
DePaul - ENG - 120
DePaul - ENG - 120
DePaul - ENG - 120
DePaul - ENG - 120
DePaul - ENG - 120
DePaul - ENG - 120
DePaul - ENG - 120
DePaul - ENG - 120
2010 Pearson Education, Inc., Upper Saddle River, NJ. All rights reserved. This material is protected under all copyright laws as they currentlyexist. No portion of this material may be reproduced, in any form or by any means, without permission in writ
DePaul - ENG - 120
11/16/2010MOMENT OF INERTIATodays Objectives:Students will be able to:1. Determine the mass momentof inertia of a rigid body or asystem of rigid bodies.In-Class Activities: Check Homework Reading Quiz Applications Mass Moment of Inertia Parall
DePaul - ENG - 120
91962_01_s12-p0001-01766/8/098:05 AMPage 1 2010 Pearson Education, Inc., Upper Saddle River, NJ. All rights reserved. This material is protected under all copyright laws as they currently exist. No portion of this material may be reproduced, in any fo
DePaul - ENG - 120
91962_03_s14_p0285-03546/8/099:40 AMPage 285 2010 Pearson Education, Inc., Upper Saddle River, NJ. All rights reserved. This material is protected under all copyright laws as they currently exist. No portion of this material may be reproduced, in any
DePaul - ENG - 120
91962_04_s15_p0355-04786/8/0911:33 AMPage 355 2010 Pearson Education, Inc., Upper Saddle River, NJ. All rights reserved. This material is protected under all copyright laws as they currently exist. No portion of this material may be reproduced, in any
DePaul - ENG - 120
3 Solutions 449181/21/094:25 PMPage 121 2010 Pearson Education, Inc., Upper Saddle River, NJ. All rights reserved. This material is protected under all copyright laws as they currentlyexist. No portion of this material may be reproduced, in any form
FH Trier - SMTH - 101
Chapter 5 and Chapter 6Sample exam questions on PricingUnderstand what the definition of price means to customers1. The key to successful pricing is to match the product with the consumer's perceptionof value.TRUESuccessful pricing considers consume
FH Trier - ENG - 101
Happy blessed, cheerful, delighted, joyful, sparklingGorgeous attractive, dazzling, delightful, pretty, stunningCreative gifted, inspired, leading-edge, productive, visionaryUnfriendly cold, grouchy, hateful, spiteful, unfavorableUpsetting annoying,
FH Trier - ENG - 101
Anton KrasinskiENG 099Professor/Instructor: Callie DossSeptember 16, 2011Adverting and Banning CigarettesAdvertising cigarettes in my opinion and many others can be crucial if youngchildren see it because they may think its a good thing to do. Smoki
FH Trier - ENG - 101
Anton KrasinskiEnglish 099Final PaperThe Future of TechnologyTechnology is changing and influencing our lives in different ways, but thepositive impacts of technology on us are more than the negative ones. One of thenegative impacts of technology on
FH Trier - ENG - 101
Anton KrasinskiENG 099Professor/Instructor: Callie DossSeptember 30, 2011Breaking the Yo-Yo Syndrome revisionsFor years, I was a yo-yo dieter, bouncing from fad diets to eating binges that leftme tired and depressed. Along the way, though, I learned
FH Trier - ENG - 101
Anton KrasinskiENG 099Professor/Instructor: Callie DossSeptember 12, 2011Chapter 4 -EssayThe weekend that I had was enjoyable and relaxing. It started off on Friday lateafternoon right after my last class of the day around 4. I went back to my dorm
FH Trier - ENG - 101
Anton KrasinskiENG 099Professor/Instructor: Callie DossOctober 26, 2011Chapter 35 The ApostrophePractice 4 on pages 486-487:(1) Sometimes, things just dont work out right. (2) Thats how the creators ofSuperman felt for a long time.(3) Supermans fi