Maxwell Company recently installed an activity-based relational database. Using the in- formation contained in the activity...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Maxwell Company recently installed an activity-based relational database. Using the in- formation contained in the activity relational table, the following activity rates have been computed: s200 per purchase order $12 per machine hour, Process R $15 per machine hour, Process D $40 per engineering hour $2 per packing order S100 per square foot Two products are produced by Maxwell: a deluxe disk player and a regular disk player. Each product has an area in the plant that is dedicated to its production. The plant has two manufacturing processes: the regular process (Process R) and the deluxe process (Process D). Other processes include engineering, product handling, and pro- curement. The product relational table for Maxwell is shown at the top of the fol- lowing page. Activity Driver Number Activity Driver Name Product Name Activity Usage Regular Regular Regular Regular Regular Regular 1 Units 800,000 1,000 320,000 5,000 400,000 6,000 100,000 500 2 Purchase orders Machine hours Engineering hours Packing orders Square footage Units Purchase orders 5 Deluxe Deluxe 40,000 6,000 100,000 4,000 Deluxe 3 Machine hours Deluxe Engincering hours Packing orders Square footage Deluxe Deluxe Required: 1. Identify two different concatenated keys. What is the purpose of concatenated keys? 2. Using the activity rates and the information from the product relational table, calculate the unit overhead cost for cach product. Maxwell Company recently installed an activity-based relational database. Using the in- formation contained in the activity relational table, the following activity rates have been computed: s200 per purchase order $12 per machine hour, Process R $15 per machine hour, Process D $40 per engineering hour $2 per packing order S100 per square foot Two products are produced by Maxwell: a deluxe disk player and a regular disk player. Each product has an area in the plant that is dedicated to its production. The plant has two manufacturing processes: the regular process (Process R) and the deluxe process (Process D). Other processes include engineering, product handling, and pro- curement. The product relational table for Maxwell is shown at the top of the fol- lowing page. Activity Driver Number Activity Driver Name Product Name Activity Usage Regular Regular Regular Regular Regular Regular 1 Units 800,000 1,000 320,000 5,000 400,000 6,000 100,000 500 2 Purchase orders Machine hours Engineering hours Packing orders Square footage Units Purchase orders 5 Deluxe Deluxe 40,000 6,000 100,000 4,000 Deluxe 3 Machine hours Deluxe Engincering hours Packing orders Square footage Deluxe Deluxe Required: 1. Identify two different concatenated keys. What is the purpose of concatenated keys? 2. Using the activity rates and the information from the product relational table, calculate the unit overhead cost for cach product.
Expert Answer:
Answer rating: 100% (QA)
1 The two Concatenated keys are Product name and activity cost driver number The purpose of Concaten... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The first activity is a hotelmotel tax that is dedicated to providing resources for building a new sports arena The mayor Phinius T Bower feels that these activities should be accounted for in a...
-
Samson Company recently installed an activity-based relational database. Using the information contained in the activity relational table, the following pool rates were computed: $400 per purchase...
-
1. When two products are produced during a common process, what is the factor that determines whether the products are joint products or one principal product and a by-product? A. relative total...
-
Write a program that takes an integer command-line argument n and creates an n-by-n boolean array a[][] such that a[i][j] is true if i and j are relatively prime (have no common factors), and false...
-
How can persistent U.S balance-of-payments deficits stimulate world inflation?
-
The Agricultural Experiment Station of a university tested two different herbicides and their effects on crop yield. From 90 acres set aside for the experiment, the station used herbicide 1 on a...
-
Understanding inventory cost data Data relevant to Job No. QV1173 are: An analysis of the production data indicate a number of additional items as follows: a. In addition to the 200 good units, there...
-
1. Many home improvement retailers like Home Depot and Lowes have lowprice guarantee policies. At a minimum, these guarantees promise to match a rivals price, and some promise to beat the lowest...
-
Following are selected balance sheet accounts of Carla Bros. Corp. at December 3 1 , 2 0 2 5 and 2 0 2 4 , and the increases or decreases in each account from 2 0 2 4 to 2 0 2 5 . Also presented is...
-
Table 1: Calculation of 3 month forward rates using the simple interest rate parity principle (4 marks) Exchange rate Forward rate 3 months Workings (show calculations in this column) from now...
-
Your aunt is trying to determine the value of her bond portfolio and turns to you for help. Find the current market values of the components of your grandmother's portfolio. a) 100 zero coupon bonds...
-
Kaya, Karatas, Gurcan, and Dalgic's "A grounded theory study to explore the digital gameplay experiences of adolescents at risk of addiction in Turkey" ( Journal of Pediatric Nursing, 63 ,...
-
Valentina lives in a "100-year floodplain" near the Yakima River. Each year she faces a 0.011 probability of a flood, that will cause $64,000 in damage if it occurs. Her annual income is $86,000....
-
Construct the probability distribution and calculate the expected value for the given scenario. Show all of your work and round your answers to the nearest hundredth, if needed. Then summarize your...
-
President and chief executive officer of the Calgary Chamber of Commerce In the year since the last iteration of the world's largest energy conference, held in Houston, energy markets have been in...
-
A helical compression spring has ( 8 total coils ) is inserted in a hole of diameter ( 7 6 . 5 mm ) . The spring is made of ( 1 2 . 5 mm ) diameter hard drawn steel wire. The spring supports an axial...
-
What is the ratio for the surface areas of the rectangular prisms shown belo given that they are similar and that the ratio of their edge lengths is 8 5 16 A 512 125 B 25 64 C 64 25 D 125 512 24 5 10...
-
Provide a few individual examples who revealed what aspects of emotional intelligence?
-
You are on the accounting staff of Chisos Manufacturing Company. Chisos has a $100 million loan with Rio Grande National Bank. One of the covenants associated with the loan is that Chisos must...
-
The following information for Whittier Technologies was taken from the company's financial statements (amounts in thousands): Instructions: 1. Compute the inventory turnover and the number of days'...
-
The following information relates to the defined benefit pension plan of Mascare Company. January 1, 2013: PBO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
-
What are the key relationships for a CEO?
-
The Walt Disney Company is engaged in the financing, production, and distribution of motion pictures and television programming. In Disneys 2004 annual report, the balance sheet contains an asset...
-
Why is the Tylenol story so instructive?
Study smarter with the SolutionInn App