2 parts to the assignment. Please quote for entire amount of work. Please use cell referencing for...

Question

2 parts to the assignment. Please quote for entire amount of work. Please use cell referencing for all.

Mohammad Wasif · Accepted Answer

InstructionsProject4
	Name:  Type your name here
	Project 4		Save your file using your first initial, last name, and name of project.
	Upload to project 4 link. 
	This project covers material assigned from following Modules: 19 and 21.
	There are 2 different parts that are not related.  Complete each part on the appropriate worksheet.
	Project 4 Objectives:
	1.  Develop a customer profitability analysis.
	2.  Recommend a course of action to management based on the customer profitability analysis.
	3.  Determine cost-based pricing.
	4.  Discuss advantages and disadvantages of cost-based pricing.
	Grading Rubric for project 4:
	Part 1
	#1. Each calculation worth .3 pt.		14.5
	#2		2
				16.5
	Part 2
	Each question worth 1.5 pts. each			13.5
	Total points Project 4			30
Part 1
	Part 1
	Aeronautics Company designs and manufactures electronic control systems for commercial airlines.  
	Aeronautics Company does contract work for the two major aircraft makers and three other companies that make the narrow-body commercial jets.
	This is a very competitive field that Aeronautics Company operates in.
	It is imperative they manage the non-manufacturing overhead costs effectively in order to achieve an acceptable net profit margin.  
	With declining profit margins in recent years, the CEO has become concerned that the cost of obtaining contracts and maintaining relations with its five customers may be getting out of hand.   
	You have been hired to conduct a customer profitability analysis.
	Below is applicable revenue and cost information you should include in your customer profitability analysis.
		Sales
	Customer 1	$3,000,000
	Customer 2	12,000,000
	Customer 3	3,000,000
	Customer 4	5,000,000
	Customer 5	2,000,000
		$25,000,000
	Cost of Good Sold (COGS)  as a percentage of sales is the following:	82%	of Total Sales generated
	Aeronautics Company selling and customer support team receives the following sales commissions on each customer account:  	4%	Sales generated per customer
	The accounting staff determined the additional selling and customer support expenses related to the following four activity cost pools and the cost per activity.

2 parts to the assignment. Please quote for entire amount of work. Please use cell referencing for all.

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment