Acctg331 Accounting Revenue And Assessment Answer
XYZ Ltd is a New Zealand company that distributes pharmaceutical products through multiple channels. It buys a variety of over-the-counter drugs from pharmaceutical companies and resells them through supermarket chains, drug store chains, and independent chemists.
With the recent announcement that the Chemist Warehouse will be entering the marketplace XYZ Ltd is anticipating changes in the profitability of its market segments. Industry observers are anticipating that the opening of the Chemist Warehouse will lead to a bloodbath in the market and competitors will have to adapt or perish. Local pharmaceutical distributors are particularly concerned they will not be able to compete with Chemist Warehouse's pricing. Accordingly, XYZ Ltd wants to analyse its market segments in order to plan how to respond to the upcoming changes.
Prepare an Excel model to analyse market segment profitability using the following data.
|
|
Supermarkets |
Department chain stores |
Chemists |
|
Average sales per delivery |
$92,500 |
$31,450 |
$6,000 |
|
Number of deliveries |
2,470 |
960 |
8,570 |
|
Average cost of goods sold per |
$83,292 |
$28,302 |
$5,355 |
|
Rebate to customers: volume based |
$205,628 |
$45,288 |
$5,142 |
|
Total number of orders |
2650 |
1,000 |
9,500 |
|
Average number of cartons shipped |
260 |
75 |
12 |
|
Customer order amendments |
7,500 |
10,000 |
22,000 |
The following information is also available about the total costs and cost drivers for key activities.
|
Activity area |
Cost driver |
Total Cost $ |
|
Customer purchase order processing |
Purchase order by customers |
591,750 |
|
Customer store delivery |
Number of deliveries |
960,000 |
|
Cartons dispatched to customer stores |
Number of cartons dispatched |
792,135 |
|
Customer service errors |
Number of corrections |
150,000 |
|
In-store promotions of XYZ brands |
? |
80,240 |
In the absence of driver information about in-store promotions, these costs are assigned based on percentage of sales.
Required
Prepare an excel-based model to analyze the profitability of XYZ Ltd.’s customer market segments. XYZ’s management team is particularly interested in identifying the margins earned (both gross and net) and cost to serve of each of its market segments.
Buy Acctg331 Accounting Revenue And Assessment Answers Online
Talk to our expert to get the help with Acctg331 Accounting Revenue And Assessment Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.
Get Online Support for Acctg331 Accounting Revenue And Assessment Answer Assignment Help Online
Resources
- 24 x 7 Availability.
- Trained and Certified Experts.
- Deadline Guaranteed.
- Plagiarism Free.
- Privacy Guaranteed.
- Free download.
- Online help for all project.
- Homework Help Services
