Create a query to shoe each activity cost

Assignment Help Case Study
Reference no: EM13492297

Job Costing system - case study

XXY   is a company that makes and sells frozen meats to locals. The meats are categorised by ingredients: beef, lamb, fish and pork.

Product Code

Ingredient

1

Beef

2

Lamb

3

Fish

4

Pork

 

XYZ meats are made to orders', and each order is treated as a job. The order table recorded by the sales, is below

Job Order Number

Product Code

Qty in unit

Job order selling price

Order Date

100

3

30

$50

01/07/2007

101

2

4

3

30

20

20

$60

01/07/2007

102

1

2

20

10

$30

01/07/2007

103

3

4

1

30

20

20

$60

01/07/2007

 

Production is arranged in batches, with each producing 50 meats. The production table, which is recorded by the supervisor, is show:

 

Production Batch Number

Job Order Number

Production Date

Beef

Lamb

Fish

Pork

1000

100

101

10/07/2007

 

 

 

10

30

 

10

1001

101

10/07/2007

 

 

20

20

10

1002

102

103

10/07/2007

 

20

10

 

20

 

1003

103

10/07/2007

 

20

 

10

20

Each batch involves 5 production activities, which comprise the cost of overhead: Case preparation, ingredients preparation, meat assembly, packaging and freezing. For overhead allocation, the number of hours spend on each process is recorded as below:

Production Batch Number

Case preparation

Ingredient preparation

Meat assembly

Packaging

Freeezing

 

1000

0.14

0.42

0.06

0.01

0.25

1001

0.16

0.42

0.07

0.01

0.25

1002

0.15

0.45

0.06

0.02

0.25

1003

0.12

0.40

0.08

0.01

0.25

 

XYZ applies a uniform overhead rate of $20 per hour to all the production activities.

XYZ uses an MS access database for sharing order, production and other information for job costing. As a cost accountant, you are required to:

  1. identify entities (tables) and attributes for a normalised data model. Show their primary keys and foreign keys, and present your indenfitication in a table with heading:

Table

Attribute name

Primary Key

Foreign Key

 

 

 

 

 

  1. Present the normalised data model (Entity Relationship) diagram in a screenshot of MS Access.
  2. Create a query to shoe each activity cost and total cost for each of the four orders. Present the query in screenshots of both design view and table view in MS Access"

Order Number

Case preparation cost

Ingredient preparation cost

Meat assembly cost

Packaging cost

Freezing Cost

Total Cost

 

 

 

 

 

 

 

 

Reference no: EM13492297

Questions Cloud

Determine the basic type of adjustment : What would be the cumulative effect on 2010 net income of all adjustments - determine the basic type of adjustment, if any, that is needed on December 31, 2010
Determine 2010 net income under cash basis : Determine 2010 net income under cash basis and accrual basis
Determine the index of the glass cube : determine the index of the glass cube n glass by assuming n air=1 and using your measured angles theta 1 and theta2 in snells law
Cumulative effect on 2010 net income : Determine 2010 net income under (a) cash basis and (b) accrual basis and what would be the cumulative effect on 2010 net income of all adjustments?
Create a query to shoe each activity cost : Create a query to shoe each activity cost and total cost for each of the four orders. Present the query in screenshots of both design view and table view in MS Access.
Determine the angular velocity of the cockroach-disk system : A cockroach of mass m lies on the rim of a uniform disk of mass 8 m that can rotate freely about its center like a merry-go-round. determine the angular velocity of the cockroach-disk system
How much work is done on the wheel : The angular momentum of a flywheel having a rotational inertia of 0.647 kg·m2 about its central axis decreases from 6.30 to 0.880 kg·m2/s in 3.00 s. How much work is done on the wheel
What is the value ofgat the location of this satellite : An artificial satellite circling the Earth completes each orbit in115minutes. (The radius of the Earth is6.38106m. What is the value ofgat the location of this satellite
Explain audit clarity project : Outline the major revisions to the auditing standards and discuss their implications for auditors conducting audits. (Approx 1,000 words essay response)

Reviews

Write a Review

 

Case Study Questions & Answers

  Assignment policy analysis hican you do this assignment

hi ltbrgt ltbrgtcan you do this assignment with the best solution please? ltbrgt ltbrgtregards q 1 i will send you the

  Case study - ebay inc internet success or fairy tale write

write the answer by reading case study - ebay inc internet success or fairy talediscuss the following questions about

  How should shirley ensure that the project is finished

Capture screenshots of the "Who does what" report that shows the tasks each resource is involved in and when they are scheduled to work on that particular task. Add the screenshots to the Word document in answer to this question.

  What are the pro and cons of a reverse merger rm

What are the pro and cons of a reverse merger RM and why would a company reverse split (RS) a stock

  Area of collection and insurance processing

How would Michele use her practicum experience to help her concentrate on improving her skills in the area of collection and insurance processing?

  Discussing the future adoption of technologies

You are to provide a one page essay for the following mini case questions (total of two pages) from the textbook. The essay is to be a 1.5 line spacing response to the following mini case.

  Case study on using technology as experience framework

he user experience framework can help designers constrain and scope the user experience of a given system. The user experience framework also informs about the relationship between a conceptual model and a user's understanding of it for past.

  Develop a long-term procedural and policy solution

The research end of the business is the well-spring from which they draw their competitive edge, but Omega is realizing that consolidating the research workforce adds synergy to their efforts, and reduces unnecessary overhead.

  Climate and geography - why they favor our mode of entry

How exactly will we enter and how it is in line with short term/long term goals, competitive analysis

  What i have wrote in my proposal

I have my proposal ready, but what I need someone gets it done for me. My Prof. is tough about the plagiarism and what I have wrote in my proposal.

  Write a draft of the proposal as your boss requested

Draft a set of ground rules for committee meetings. Try to suggest rules that will minimize political differences and focus on the overall benefit to the company.

  Discuss critically infosys current and future strategy

Discuss critically Infosys current and future strategy. What advice would you give Kris Gopalakrishnan and KShop has resulted in information overload among staff. What operational measures would you suggest to overcome such challenges?

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