Activity-Based Costing

Instructions

All information required for this assignment is provided in the Unit 2 Student WorkbookPreview the document [Excel] for this unit.

Read the Chandler CorporationPreview the document [PDF] case study and complete the following requirements.

Quantitative Analysis: 

Chandler Corporation is currently producing several products, including both custom and standard designs. It has received requests for two new products: swimming pool shades and landscape trellises. It is considering whether to produce either or both of these products. Based on the projections in Exhibits 1 to 3 describing the current capacity and required capacity needs for the new products, complete the following requirements:

  1. Using ABC, compute the Predetermined Overhead Rate for each activity.
  2. Compute the cost of unused capacity for each activity and in total.
  3. Compute the TOTAL and UNIT cost of making the full demand of pool shades assuming that Chandler bases its rates on the predetermined overhead rate.
  4. Compute the TOTAL and UNIT cost of making the full demand of trelli, assuming that Chandler bases its rates on the predetermined overhead rate.
  5. Compute the TOTAL and UNIT cost of making the full demand of pool shades assuming that Chandler bases its rates on EXPECTED capacity (used capacity plus required capacity for the full demand of pool shades).
  6. Compute the total and unit cost of making the full demand of trellises assuming that Chandler bases its rates on EXPECTED capacity (used capacity plus required capacity for the full demand of trellises).

Qualitative Analysis:

In a 2-3 page report, based on your quantitative analysis, discuss the results of what your quantitative analysis means for Chandler.  When considering a decision to make the new products, would costs computed using practical capacity (c and d) or expected capacity (e and f) as the denominator provide better information to Chandler’s management? Explain your answer.  Support your recommendation with a minimum of 3 academic resources.

READ this: Please make sure prepare a 2-3 page summary

Deliverables

  • Quantitative Analysis (Excel Required): You are required to use the provided Excel workbook to complete the quantitative analysis for this assignment.
  • Qualitative Analysis (Word Required): Prepare a 2-3 page summary addressing the required qualitative analysis, as noted in the Student Workbook.  Your paper is required to be formatted according to APA requirements.  Be sure to incorporate key concepts from this unit’s readings and properly cite your references according to APA requirements.  Do NOT embed the results of your quantitative analysis in your Word document.  You should only reference parts of your quantitative analysis in your written analysis.  Your written responses to the qualitative prompts should not be presented in a question and answer format.

Assignment Resource(s)

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

BUS 515 FINAL EXAM PART 1 & 2

PART 1

Chapter 6

Multiple Choice Question 19

What measures the central tendency of a set of data?

Coefficient of variation

Variance

Standard deviation

Mean

Range

 

 

 

 

Multiple Choice Question 39

Consider a p-chart measuring the percentage of defective light bulbs. If the LCL is .04 and a sample has 1% defects, what is the implication?
The process is in a state of control.

The process is out of control even though the variation is “good.”

The value of sigma must be increased.

The process has too many errors.

http://edugen.wiley.com/edugen/art2/common/pixel.gif A calculation error must have occurred

 

Multiple Choice Question 16

An OC curve is an example of what?
Traditional statistical tools

Fishbone diagramming
Acceptance sampling

Experimental design

Statistical process control

Multiple Choice Question 25

On a control chart, what separates common from assignable causes of variation?

x-bar lines

Control limits

Specification limits

Production limits

Mean divided by standard deviation

Multiple Choice Question 41

What are preset ranges of acceptable quality characteristics?

Control limits

Product specifications

Six-sigma limits

AQC limits

R-chart limits
Chapter 7

Multiple Choice Question 26

According to JIT, __________ is carried to cover up a wide variety of problems, such as poor quality, demand uncertainty, and slow delivery.

Inventory

Excess capacity

A group of back-up workers

Spare equipment

Insurance
Multiple Choice Question 65

Which of the following is not a role of JIT management?
creating a JIT culture
cost and information sharing

serving as coaches and facilitators

developing an incentive system

ensuring multifunctional training occurs

Multiple Choice Question 36

JIT uses a pull system where communication starts with either the customer or with the _________ work station in the production line.
First

Bottleneck

Dominant

Most expensive

Last

http://edugen.wiley.com/edugen/art2/common/pixel.gifMultiple Choice Question 61

JIT production workers are expected to

Cover up quality problems

Ignore data

Take responsibility in getting to the root cause of quality problems

Blame problems on someone else
Have a poor attitude about quality

Multiple Choice Question 70

The benefits of long-term relationships with a small number of suppliers include all of the following except
Always getting the lowest price

Focus on improving process controls

Greater accountability

Develop stable delivery schedules

Eliminate paperwork

Chapter 8

Multiple Choice Question 1

Forecasting is not a function which contributes to:
deciding which business market to pursue

deciding which product to produce

http://edugen.wiley.com/edugen/art2/common/pixel.gifdeciding how bonuses should be allocated

deciding how much inventory to carry

deciding how many people to hire

Multiple Choice Question 10

Which forecasting method is particularly good for predicting technological changes and scientific advances?
Market research

Executive opinion

Delphi method

NaĂŻve method

Gamma method

Multiple Choice Question 30

What are the most frequently used forecasting techniques?
Linear regression

Simple mean
Exponential smoothing

Weighted moving average

Econometric models

Multiple Choice Question 17

Which of the following is a causal forecasting method?
NaĂŻve

Moving average

Weighted moving average

Trend adjusted exponential smoothing

Linear regression

Multiple Choice Question 74

“Inside information” is most likely garnered through which of the following forecasting methods?
exponential smoothing

seasonal indexes

naĂŻve

Delphi

multiple regression

http://edugen.wiley.com/edugen/art2/common/pixel.gifChapter 9

Multiple Choice Question 56

The least likely reason for a U.S. firm to choose to locate a factory in a foreign country is _____________.
climate

Natural resources

markets

cheaper suppliers

low labor costs

Multiple Choice Question 55

Issues that need to be considered in location globally include all of the following except______________.
different cultures

FEC accounting requirements

language barriers

different laws
different business practices

Multiple Choice Question 6

Capacity planning is complicated by the fact that ___________________.

capital markets are complex

existing facilities may become obsolete

capacity is difficult to define

capacity is usually purchased in chunks, rather than smooth increments

depreciation must be calculated
Multiple Choice Question 44

Service organizations such as restaurants, movie theaters, and banks focus on locating near ____________.
suppliers

roads

intersections

their customers

potential workers

Multiple Choice Question 25

Management has decided to add capacity incrementally in smaller chunks as needed, rather than purchasing one large facility. This decision ____________________.
is very risky

will result in low initial costs

will ultimately result in lower costs per unit if demand increases rapidly
positions the company to be well prepared for high demand in the future

can lead to a large amount of excess capacity

 

Chapter 10

Multiple Choice Question 34

The first step in designing a layout is
identifying the facility

gathering information

selecting the correct layout software package

developing a REL chart

developing a from-to matrix
Multiple Choice Question 65

What is the term for a system in which the product being worked on is physically attached to the line and automatically moved to the next station when the cycle time has elapsed?
cyclical line

paced line

http://edugen.wiley.com/edugen/art2/common/pixel.gifautoline

continuous line

constrained line
Multiple Choice Question 4

Which of the following is not one of the four basic layout types?

product

hybrid

process

fixed position

inverted

Multiple Choice Question 27

Which company is widely considered to be the leader of just-in-time production?
Ford

Timex

Gateway

Toyota

Sony

Multiple Choice Question 24

A high-volume paper mill is an example of which layout type?

inverted

circular

process

fixed position

product

 

PART 2

Multiple Choice Question 43

For each work element in the time study, multiplying the mean observed time by the performance rating factor by the frequency of occurrence results in what?
the normal time for the element
the average observed time for the element

the standard time for the element

the average delay for the element

the standard time for the job
Multiple Choice Question 21

The approach that details the tasks of a job and how to do them is ____________________.
work measurement
job evaluation

methods analysis
job design

work sampling

Multiple Choice Question 64

Disadvantages of individual incentive systems include all except which of the following?
They undermine teamwork.
A study has shown they had no effect on worker performance

They avoid the “free-rider” problem

They need a significant amount of data collection

They give employees a short-term focus.
Multiple Choice Question 3

Job design ensures that each employee’s _________ and ________ are geared towards achieving the company’s mission.
compensation, teams

duties, teams

satisfaction, compensation

duties, responsibility

compensation, responsibility
Chapter 12

Multiple Choice Question 17

Companies can achieve cost-efficient operations by using which of the following inventory approaches?
work-in-process to buffer operations

inventory building to leverage reduced setup costs
JIT inventory to reduce overall cost
level work force maintenance through

speculative selling

Multiple Choice Question 27

Which of the following is an assumption of the basic EOQ model?
Lead time is known and constant.
Demand may be seasonal.
Orders can arrive in partial shipments.
Quantity discounts are considered

Lost sales are allowed, but not back orders.
Multiple Choice Question 5

Which inventory function specifically is designed to allow the company to maintain a level production strategy?
anticipation inventory

fluctuation inventory

lot-size inventory

transportation inventory

speculative inventory
Multiple Choice Question 20

Which of the following is not affected by decisions about how much inventory to hold?
item costs

holding costs

depreciation

ordering costs

stockout costs

Chapter 13

Multiple Choice Question 16

What type of aggregate plan sets labor and equipment capacity to satisfy demand each period?

uniform

level

chase

mixed

steady
Multiple Choice Question 32

The comparison of aggregate plans is difficult when they produce different quantities and thus _________.

have different ending inventories

have different staffing levels

have different amounts of overtime

have different amounts of subcontracting
have different revenues
Multiple Choice Question 38

Once you implement a new aggregate plan you must then:
begin the planning process again

evaluate the plan’s performance in terms of cost.
evaluate the plan’s performance in terms of customer service

evaluate the plan’s performance in terms of human resources.
evaluate the plan’s performance in terms of cost and human resources

Multiple Choice Question 53

The master production schedule is shared:
only internally

only with management

only to marketing and engineering.
to all members of the executive team, exclusively

to all members of the supply chain

Chapter 14

Multiple Choice Question 34

Information in the inventory records file that can change with inventory transactions includes the ________.

part number

lot size rule
projected inventory level

lead time

safety stock requirement
Multiple Choice Question 31

The quantity of the replenishment order is based on the __________________________.
capacity available

size of the item

number of workers available

inventory space available

lot sizing rule used
Multiple Choice Question 58

An action notice is generated ________________________________________.
for planned orders in any period

only for orders that are to be released to the shop floor
only for movements to and from the warehouse
only when marketing needs to be notified

when a planned order needs to be released

Multiple Choice Question 12

ERP systems provide _____ and _____ benefits.
tangible, HR

intangible, marketing

marketing, operation

tangible, intangible

CEO, CFO

http://edugen.wiley.com/edugen/art2/common/pixel.gifChapter 15

Multiple Choice Question 3

Scheduling in the high-volume environment is typically done through what?

priority rules

line design and balancing

Thompson’s rule

Simpson’s rule
Johnson’s rule

Multiple Choice Question 65

The process batch should:
match the transfer batch

exceed the transfer batch

be smaller than the transfer batch.
be fixed

be variable

Multiple Choice Question 16

If the schedule shows a 5 day slack between the end of Task A and start of Task B, this means:
You must start Task B as soon as Task A ends

Task B start is late

Task A is taking longer to complete

Task A and Task B should be performed concurrently

Task B start can be delayed up to 5 days after Task A’s scheduled completion

Multiple Choice Question 12

Which of the following scheduling techniques determines the earliest possible completion time for a job?
finite loading

infinite loading

forward scheduling

backward scheduling

input/output control

Chapter 16

Multiple Choice Question 27

In making a forward pass through a network, three activities are immediate predecessors for activity T. What is the early start time for activity T?
the smallest ES for the three activities that are immediate predecessors for activity T
the largest ES for the three activities that are immediate predecessors for activity T

the smallest EF for the three activities that are immediate predecessors for activity T

the largest EF for the three activities that are immediate predecessors for activity T

the activity time for activity T

Multiple Choice Question 67

One way of wasting safety time in the critical chain approach is multitasking, which involves ___________.
waiting until the last minute to start a project
interaction among project activities

having the computer operating system do everything

using a person or resource for more than one project

reversing the order of the activities

Multiple Choice Question 8

Which phase in the project life cycle involves analyzing the project risk?
conception

feasibility analysis or study

planning

execution

termination

Multiple Choice Question 18

The critical path is the sequential path of interrelated activities which has the ____________________.
most activities

longest time

most nodes

most events

most arrows
Multiple Choice Question 71

PERT is credited with reducing the duration of the Polaris missile project by _________________.
one year

two years

three years

four years

five years

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 

http://edugen.wiley.com/edugen/art2/common/pixel.gif

 

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Not All Companies Are Viewed as Equal

Business Ethics – 2 Page Assignment

*** NO PLAGIARISM PLEASE.***

Assignment 1: Not All Companies Are Viewed as Equal

In the land of free trade, the public does not view all industries as equal. Do you believe that is ethical? Do you believe that some industries are unfairly targeted? Should it be consumers’ choice to partake in products that are not healthy for them, or do those companies have an ethical obligation to protect people? In this assignment, you will choose one (1) industry to write about. Possible industries to research could be tobacco, soda, alcohol, casinos, or candy companies, just to name a few.

Write a one and a half to two (1½ – 2) page paper in which you:

  1. Become an advocate for either the consumer or the industry. Prepare an argument explaining the major reasons why you support either the consumer or the industry.
  2. Explain the role capitalism plays in corporate decision making.
  3. Discuss if you believe it is possible for a company to cater to both its best interest and that of the consumer conjointly or if one always has to prevail. Justify your response.
  4. Use at least two (2) quality references. Note: Wikipedia and similar Websites do not qualify as academic resources.
  5. Format your assignment according to the following formatting requirements:
        1. Typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
        2. Include a cover page containing the title of the assignment, your name, your professor’s name, the course title, and the date. The cover page is not included in the required page length.
        3. Include a reference page. Citations and references must follow APA format. The reference page is not included in the required page length.

The specific course learning outcomes associated with this assignment are:

  • Determine the considerations for and process of ethical business decision making to balance corporate and social responsibilities, and address moral, economic, and legal concerns.
  • Analyze selected business situations using the predominant ethical theories, such as utilitarian, Kantian, and virtue ethics to guide ethical business decision making.
  • Use technology and information resources to research issues in business ethics.
  • Write clearly and concisely about business ethics using proper writing mechanics.

*******GRADING RUBIC BELOW**********

Assignment 1: Not All Companies Are Viewed as Equal
Criteria Unacceptable

Below 60% F

Meets Minimum Expectations

60-69% D

Fair

70-79% C

Proficient

80-89% B

Exemplary

90-100% A

1. Prepare an argument explaining the major reasons why you support either the consumer or the industry.
Weight: 35%
Did not submit or incompletely prepared an argument explaining the major reasons why you support either the consumer or the industry. Insufficiently prepared an argument explaining the major reasons why you support either the consumer or the industry. Partially prepared an argument explaining the major reasons why you support either the consumer or the industry. Satisfactorily prepared an argument explaining the major reasons why you support either the consumer or the industry. Thoroughly prepared an argument explaining the major reasons why you support either the consumer or the industry.
2. Explain the role capitalism plays in corporate decision making.

Weight 20%

Did not submit or incompletely explained the role capitalism plays in corporate decision making. Insufficiently explained the role capitalism plays in corporate decision making. Partially explained the role capitalism plays in corporate decision making. Satisfactorily explained the role capitalism plays in corporate decision making. Thoroughly explained the role capitalism plays in corporate decision making.
3. Discuss if you believe it is possible for a company to cater to both its best interest and that of the consumer conjointly or if one always has to prevail. Justify your response.

Weight 20%

Did not submit or incompletely discussed if you believe it is possible for a company to cater to both its best interest and that of the consumer conjointly or if one always has to prevail. Did not submit or incompletely justified your response. Insufficiently discussed if you believe it is possible for a company to cater to both its best interest and that of the consumer conjointly or if one always has to prevail. Insufficiently justified your response. Partially discussed if you believe it is possible for a company to cater to both its best interest and that of the consumer conjointly or if one always has to prevail. Partially justified your response. Satisfactorily discussed if you believe it is possible for a company to cater to both its best interest and that of the consumer conjointly or if one always has to prevail. Satisfactorily justified your response. Thoroughly discussed if you believe it is possible for a company to cater to both its best interest and that of the consumer conjointly or if one always has to prevail. Thoroughly justified your response.
4. 2 references

Weight: 10%

No references provided Does not meet the required number of references; all references poor quality choices. Does not meet the required number of references; some references poor quality choices. Meets number of required references; some references high-quality choices. Meets number of required references; all references high-quality choices.
5. Clarity, writing mechanics, and formatting requirements

Weight: 15%

More than 8 errors present 7-8 errors present 5-6 errors present 3-4 errors present 0-2 errors
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Data Analytics Requirement

In this case, you will use Tableau to analyze the sales and cost transactions for an insurance company. You will first have to find and correct errors in the data set using Excel. Using Tableau, you will then sort the data, join tables, format data, filter data, create a calculated field, create charts, and other items, and will draw conclusions based on these results.

1

A325 Cost Accounting

Data Analytics Case – KAT Insurance Corporation Student Guide for Tableau Project

Overview In this case, you will use Tableau to analyze the sales and cost transactions for an insurance company. You will first have to find and correct errors in the data set using Excel. Using Tableau, you will then sort the data, join tables, format data, filter data, create a calculated field, create charts, and other items, and will draw conclusions based on these results.

General learning objectives 1. Clean the data in a data set 2. Analyze sales trends 3. Interpret findings

Tableau learning objectives 1. Join two tables 2. Create calculated fields 3. Build visualizations by dragging fields to the view 4. Format data types within the view 5. Filter data in Tableau visualization 6. Format data within the Tableau visualization 6. Utilize the Marks card to change measures for sum, count and average 8. Sort data in visualization by stated criteria 8. Create a bar chart in the view 10. Create a map chart

 

 

2

Background This KAT Insurance Corporation data set is based on real-life data from a national insurance company. The data set contains more than 65,000 insurance sales records from 2017. All data and names have been anonymized to preserve privacy.

Requirement A (60 points) The original data set has typographical errors in the Region and Insurance Type fields. Use Excel to find and correct those errors in the data set.

You will turn in a Tableau file with .twbx extension showing the completed results in tables AND graphs to support the following tasks.

• Generate a new sheet AND a graph ranking profitability by insurance type. The profitability is measured by total contribution margin.

• Generate a new sheet AND a graph ranking profitability by insurance type. The profitability is measured by contribution margin ratio.

• Generate a new sheet AND a graph ranking profitability by state. The profitability is measured by contribution margin ratio.

• Generate a map chart to show profitability of each state on the map.

Requirement B (40 points) Answer the following questions.

1. What is the trend or takeaway you have observed in the results of profitability ranking (total contribution margin) by insurance type?

2. What is the trend or takeaway you have observed in the results of profitability ranking (contribution margin ratio) by insurance type?

3. Does the ranking by total contribution margin look similar to the ranking by contribution margin ratio? Explain why they agree or disagree.

4. Based on your answers for Requirement A, what was the average of the contribution margin for home insurance sales?

5. Based on your answers for Requirement A, what was the sum of the contribution margin ratio for professional insurance?

6. Based on your answers for Requirement A, what was the sum of the contribution margin ratio for Pennsylvania

7. Based on your answers for Requirement A, what state had the highest sum of contribution margin? 8. Based on your answers for Requirement A, what was the most profitable state in the Midwest

region as measured by the contribution margin?

Data dictionary for main data set • Region: This field contains the region in which the insurance was sold. There are six regions:

Midwest, New England, North Central, Northeast, Southeast, and West. • State: This field contains the state in which the insurance policy applies. The data is from sales

to the 48 states in continental US and the District of Columbia. (KAT Insurance does not offer insurance in the states of Alaska and Hawaii.)

• Salesperson: This field contains the name of the salesperson who sold the policy.

 

 

3

• Insurance Type: This field contains the type of insurance policy. • State Type: This field is a combination of the State and Insurance Type fields. • Sales: This field contains the selling price of the insurance policy. • Date of Sale: This field contains the date that the policy was sold. • Invoice No: This field contains the invoice number. • Country: This field contains the country in which the policy was sold. At this time, KAT Insurance

only sells policies in the US. • Variable Cost Percent: This field contains the variable cost of each policy.

 

  • A325 Cost Accounting
  • Data Analytics Case – KAT Insurance Corporation Student Guide for Tableau Project
    • Overview
    • General learning objectives
    • Tableau learning objectives
    • Background
    • Requirement A (60 points)
    • Requirement B (40 points)
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"