Job support activity cost pools

Assignment Help Database Management System
Reference no: EM13646458

Jared Painting paints the interiors and exteriors of homes and commercial buildings. The company uses an activity-based costing system for its overhead costs. The company has provided the following data concerning its activity-based costing system.

 

Activity Cost Pool

Activity Measure

Annual Activity

 

Painting overhead..............

Square meters

10,000

square meters

 

Job support.........................

Jobs

200

jobs

 

Other..................................

None

Not

applicable

The "Other" activity cost pool consists of the costs of idle capacity and organization-sustaining costs.

The company has already finished the first stage of the allocation process in which costs were allocated to the activity cost centers. The results are listed below:

 

 

 

Job

 

 

 

 

Painting

Support

Other

Total

 

Painting overhead.....

$  99,000

$  45,000

$36,000

$180,000

 

Office expense..........

     6,000

   78,000

 36,000

 120,000

 

Total..........................

$105,000

$123,000

$72,000

$300,000

Required:

a. Compute the activity rates for the Painting and Job Support activity cost pools by filling in the table below. Round off all calculations to the nearest whole cent.

 

 

 

Job

 

 

Painting

Support

 

Painting overhead.....

 

 

 

Office expense..........

 

 

 

Total..........................

 

 

b. Prepare an action analysis report in good form of a job that involves painting 71 square meters and has direct materials and direct labor cost of $2,410. The sales revenue from this job is $3,800.

For purposes of this action analysis report, direct materials and direct labor should be classified as a Green cost; painting overhead as a Red cost; and office expense as a Yellow cost.

Reference no: EM13646458

Construct a b+ tree

Construct a B+ tree for the following set of key value (2,3,5,7,11,19,23,29,31) in ascending order where the pointers that will fit in one node is as follows:A. four B. six

Design a database - what is the purpose of your database

Design a database, a database planner should spend a considerable amount of time thinking about what kind of information will be included in the database and how it will be

Practice of optimizing table structures

Database normalization can principally be cleared as the practice of optimizing table structures. Optimization is adapted as a result of a thorough investigation of the nume

Create a table called temp-student with the columns

Create a table called TEMP_STUDENT with the following columns and constraints: a column STUD_ID for the student ID and is the primary key, a column FIRST_NAME for student fi

Design a data warehouse for chemist warehouse

Design a data warehouse for Chemist Warehouse using multidimensional Modelling - What particular product is most popular across nation, what is the total sales in past 3 years

Develop a table mainmenu with at least three fields

Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run. Your code (for the button) will dynamically read the caption from the table and as

Explain the benefits and current trends of data warehousing

Summarize the difference between online transaction processing (OLTP) and online analytic processing (OLAP), and their relationship among business intelligence, data warehou

Does every database table require a primary key

Does every database table require a primary key? Explain why or why not and provide an example to support your response.Assume that you are developing REA diagrams for a large

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd