<\/p>\n
The answer should be done in Excel, each problem set should be done in one sheet<\/p>\n
Answers to <\/p>\n Probleem set 1<\/p>\n <\/p>\n Mace Windu Duke Skywalker owns and operates \u201cThe Force Company\u201d a light sabre producing company. He is considering the introduction of a new custom light sabre that he estimates will generate demand for 8,000 light sabers. The sabers will sell for $100.00 each, with a unit variable cost of $40.00, and annual fixed costs of $600,000. Required: 1. Determine the number of sabers to be sold to break-even. 2. Determine the number of sabers to be sold to earn an operating profit of $22,000. 3. What is the safety margin in units when the company makes an operating profit of $22,000? 4. If 8,600 sabers are sold, determine the operating income. If sales price was increased by 15 percent, variable cost per unit increased by 10 percent, and fixed cost increased by $6,000, determine the new break-even point.<\/p>\n <\/p>\n Please put it in Excel and utilize as many formulas as possible<\/p>\n <\/p>\n Problem set 2<\/p>\n <\/p>\n Ramses Manufacturing manufactures several products. Phoenix has adopted the traditional overhead allocation method for allocating manufacturing overhead, and direct labor hours have been selected as the cost driver. Phoenix budgeted the production for 15,000 units for 2012 with budgeted total direct labor hours of 6,000 hours at a standard wage rate of $20 per hour, and total manufacturing overheads at $263,100. Mr. Tiger Smith, CFO of Phoenix, is considering switching to the activity-based costing (ABC) system due to several significant changes in its production process. Information pertained to ABC for the year is presented as follows:<\/p>\n <\/p>\n Cost pool<\/p>\n<\/td>\n Total costs<\/p>\n<\/td>\n Total activity<\/p>\n<\/td>\n<\/tr>\n Assembly<\/p>\n<\/td>\n $153,000<\/p>\n<\/td>\n 12,750 machine hours<\/p>\n<\/td>\n<\/tr>\n Material handling<\/p>\n<\/td>\n 94,500<\/p>\n<\/td>\n 5,250 orders<\/p>\n<\/td>\n<\/tr>\n Inspection<\/p>\n<\/td>\n 15,600<\/p>\n<\/td>\n 1,560 inspection-hours<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n <\/p>\n Ramses received an order of 1,000 units of one of its several product lines, Frames (referred to as Job101). The following data are related to the production and sales of these Frammises :<\/p>\n <\/p>\n Machine hours 1,400<\/p>\n <\/p>\n Material handling-orders 400<\/p>\n <\/p>\n Inspection hours 170<\/p>\n <\/p>\n Direct materials cost per unit $120<\/p>\n <\/p>\n Direct labor hours 300<\/p>\n <\/p>\n Required: 1. Calculate the predetermined rate under the traditional allocation method.<\/p>\n <\/p>\n 2. Calculate the total product costs and unit costs under the traditional allocation method for Job101.<\/p>\n <\/p>\n 3. Calculate the activity cost pool rates for each of its activity cost pools listed.<\/p>\n <\/p>\n 4. Calculate the total product costs and unit costs under the ABC method for Job101.<\/p>\n <\/p>\n 5. Which method is more preferable? Why (give at least two reasons<\/strong>)<\/p>\n <\/p>\n Please put it in Excel and utilize as many formulas as possible <\/p>\n <\/span>\n<\/div>\n","protected":false},"excerpt":{"rendered":" The answer should be done in Excel, each problem set should be done in one sheet Answers to computational problems must be adequately supported. it should follow the exact form as the text book mentioned. Textbook: Managerial Accounting, 15th Edition, Garrison, Noreen and Brewer, 2015 Probleem set 1 Mace Windu Duke Skywalker owns and operates […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/178844"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=178844"}],"version-history":[{"count":0,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/178844\/revisions"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=178844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=178844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=178844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\ncomputational problems must be adequately supported. it should follow the exact form as the text book mentioned. Textbook:<\/strong> Managerial Accounting, 15th Edition, Garrison, Noreen and Brewer, 2015<\/strong><\/span><\/p>\n
<\/span><\/p>\n\n\n
\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
Label your answers and put them in final form as appropriate<\/strong><\/p>\n