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...
-
Oculus and Maxygen are small drug companies. Oculus has obtained a patent on a new antibiotic that is effective against an emerging superbuga bacteria that is resistant to traditional antibiotics....
-
Explain Liquidity and Efficiency ratio and explain how each of the ratios within that class is calculated and how they are used to analyze financial statements. Then, select a recently filed set of...
-
Understanding whether agreed-upon procedures relate to a specified element, account, or item of a financial statement or to a nonfinancial statement assertion is important because the professional...
-
On January 2, Year 1, Poplar Ltd. purchased 80% of the outstanding shares of Spruce Ltd. for $2,000,000. At that date, Spruce had common shares of $500,000 and retained earnings of $1,250,000 and...
-
Planning review, control and monitoring is an essential feature of strategic planning activities. For this task you are required to consider the time lines, activities, possible budgetary factors,...
-
What type of web server is sending packet/frame 280 of the capture? 2. What type of HTTP Status Code is the web server in packet/frame 314 sending? Google the error and provide a quote summarizing...
-
The following data is provided for Garcon Company and Pepper Company for the year ended December 31. Finished goods inventory, beginning Work in process inventory, beginning Raw materials inventory,...
-
How is the Gini coefficient calculated and what does it show?
-
A circular loop of diameter \(150 \mathrm{~mm}\) is placed on a wooden table that makes angle of \(24.5^{\circ}\) with a uniform magnetic field. What must be the magnitude of the magnetic field if...
-
What are the limitations of using GDP as a measure of well-being for a country?
-
Explain the Lorenz curve and what it measures.
-
List the capital inputs necessary to produce each of the following: a. cars b. secondary education c. air travel d. fruit and vegetables.
-
1 : Has the outbreak of the coronavirus affected the demand, the supply side of the market or both if we consider the world as one country for the market of gasoline? If it affects both, in what...
-
How do individual companies respond to economic forces throughout the globe? One way to explore this is to see how well rates of return for stock of individual companies can be explained by stock...
-
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 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
-
The y-intercept b0 of a least-squares regression line has a useful interpretation only if the x-values are either all positive or all negative. In Exercises 812, determine whether the statement is...
-
In general, the slope of the least-squares regression line is equal to the correlation coefficient. In Exercises 812, determine whether the statement is true or false. If the statement is false,...
-
At the final exam in a statistics class, the professor asks each student to indicate how many hours he or she studied for the exam. After grading the exam, the professor computes the least-squares...
Study smarter with the SolutionInn App