Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please answer the questions using excel spreadshee

Please answer the questions using Excel spreadsheet or Word. Neat and understandable. Show All Working!...

70.2K

Verified Solution

Question

Accounting

Please answer the questions using Excel spreadsheet or Word. Neat and understandable. Show All Working!

image

PROBLEM 3 (CVP Analysis & Incremental Analysis) Part A 15 Marks Intune Global is undergoing an analysis of one of the products it produces, the Applicator 2000. Each Applicator 2000 is sold for $40. 3 4 The following information on the product's total costs over the past five (5) months is provided below: Month Units Total Costs ($) 1 1,250 38,000 2 1,750 41,750 2,350 55,080 2,100 48,100 5 3,000 59,000 Required: a) Using the High-Low method, calculate: i. The Applicator 2000's variable cost per unit. 3 Marks ii. The product's monthly fixed costs. 3 Marks b) Based on your answer above, compute the product's contribution margin per unit and contribution margin ratio. 3 Marks c) If the company wants to earn a target income of $61,000 on this product, compute the level of sale dollars required. 3 Marks d) If the company achieves this level of sales (from part c), compute Intune's margin of safety in dollars with respect to the Applicator 2000. 3 Marks

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students