Question

In: Accounting

Job Costing – Cookie Experiment- To celebrate your new found knowledge of Job Costing, you and...

Job Costing – Cookie Experiment-

To celebrate your new found knowledge of Job Costing, you and a classmate (or can be completed individually) will make at least one dozen of cookies and track the cost of the cookies and the process.

Requirements: Track the Direct Materials, Direct Labor and MOH cost for making cookies. Cookies must be made from scratch. No Betty Crocker (or other brand) mixes.

  1. For Direct Material, include all ingredients and calculate the cost of DM used of each ingredient.

Hint. Not all ingredients will be DM. Is a teaspoon of baking soda a DM or indirect material?

Please separate DM and Indirect Materials. Both categories must show the total cost of each ingredient and cost of ingredient used!

  1. For Direct Labor, complete some research and find the hourly rate of a baker. Based on the time actually working on the cookies (not baking time) calculate the labor.

Hint: DL time would include prep, mixing, & clean-up.

  1. MOH: For this assignment MOH will include indirect labor and other costs. Indirect Material will be calculated in step 1 and show separately from MOH.
    1. Possible items to include (there may be more!) when calculating Overhead: water for cleaning, utensils, cleaning supplies, electricity, rent, etc. Full points earned for listing items not included in the previous sentence.

  1. For MOH costs, please determine a PDOR Rate for the total SUM OF MOH and CHOOSE ONE allocation base (cost driver) to assign a portion of the MOH costs to the cookies. Must have at least 5 MOH costs.
    1. Recommendation: Calculate the MOH costs for a month and assign to the cookie job based on a single allocation driver.

  • Demonstration of calculation of MOH: Please note, this example or allocation rate (hours in a month) cannot be used for your assignment)
    • If calculated my MOH Costs for a month I would have:

$900 Monthly Rent + $45 Monthly Electricity + $10 Monthly cleaning supplies + $35 Monthly water = $990 of total MOH for one month. I could allocate these costs to my cookies based on baking time of the cookies, total Direct Labor time, etc. I chose total hours in a month, 744. if my cookies took a total of 45 minutes to make (from start to finish) I could determine a rate by the following: $990/744 hours (total hours in a month) = $1.33 per hour.

  • To assign the MOH, then I use the formula Actual Activity * PDOR. Therefore $1.33 * 45/60 = $ .9975. This would be the MOH portion of my Product Costs.

Questions to answer: Work must be completed in EXCEL.

  1. Provide an itemized list of all Direct Material, Indirect Material and Direct Labor Costs. Please indicate any calculations performed to determine Direct Material used or Direct Labor costs. Calculations must be completed in Excel.
    1. Example: 1 cup of sugar is required. The 5 lb bag of sugar has 10 cups. (Remember your conversion skills or look them up online). In Excel show the calculation of the cost of the 1 cup of sugar. Assume bag of sugar costs $2.29 per bag, then in Excel a calculation similar to = 2.29 * (1/10) = $.23 per cup of sugar is completed.

  1. What items did you include in the MOH costs? Please list the items and the total costs for those MOH items.

FOR MOH, it is recommended to have two categories:

  • MOH Allocated. Based on other MOH Costs (Rent, Water, Electricity, etc) and allocated using a PDOR. Please remember these MOH Costs should be calculated as a total. For example, I would use rent for a month or monthly water bill. The PDOR will allocate the appropriate portion of the cost to the cookies. Please refer to the example on the previous page.

  1. What allocation base did you choose to assign the MOH costs to the cookies and why was this allocation base chosen?

  1. What was the PDOR. Please show the PDOR calculation.

  1. How much MOH was assigned to the cookie job?

  1. How many cookies were made?

  1. What was the total cost of the cookie job? This will include DM + DL + Indirect Materials + MOH Allocated in step 2.

  1. What was the cost per cookie?

  1. Based on the cost per cookie, what is your recommended selling price per cookie?

  1. What mark-up percentage did you choose?

Solutions

Expert Solution

Please give positive rating your feedback is valuable to me.

In case , any problem please leave a comment .


Related Solutions

Describe the relationship between the AACN Essentials and your new-found knowledge about Patient Centered Care. Are...
Describe the relationship between the AACN Essentials and your new-found knowledge about Patient Centered Care. Are there opportunities for you to improve? Essential VIII: Professionalism and Professional Values discusses professional standards of moral, ethical, and legal conduct. Review the Professional Integrity Module-Academics and Practice at the beginning of the course (the first module). Then reflect on your own beliefs and values as they relate to professional nursing practice. Discuss implications of professional nursing integrity and academic integrity.
How can you use your knowledge of OB to enhance your job performance and career? Give...
How can you use your knowledge of OB to enhance your job performance and career? Give one example of how OB could increase your effectiveness in the classroom or in a corporate environment. Do you think OB is only helpful in a work environment, or could it help you in your personal life? Why or why not?
Compare and contrast the job-order costing method with the activity-based costing method. If you had your...
Compare and contrast the job-order costing method with the activity-based costing method. If you had your own business which would you prefer and why?
Differentiate between job costing and process costing with your own examples
Differentiate between job costing and process costing with your own examples
As you like an adventure! assume that to celebrate graduation from Seneca College, you and your...
As you like an adventure! assume that to celebrate graduation from Seneca College, you and your friends do a road trip ‘out west’. Along the way, you accept an entry-level human resources position in a global oil/gas drilling company - based in Calgary. The company is sending a team of four drill crew to Qatar for four-months. Three of the crew are male and will work exclusively in the field, one of the crew is female and will support drilling...
How do you see your new knowledge of Excel affecting you? It can be business or...
How do you see your new knowledge of Excel affecting you? It can be business or personal.
It’s your birthday, and to celebrate you’re going to make your first bungee jump. You stand...
It’s your birthday, and to celebrate you’re going to make your first bungee jump. You stand on a bridge 100 m above a raging river and attach a 30-m-long bungee cord to your harness. A bungee cord, for practical purposes, is just a long spring, and this cord has a spring constant of 40 N/m. Assume that your mass is 80 kg. After a long hesitation, you dive off the bridge. How far are you above the water when the...
You have just started a new job and are thrilled to learn that your new employer...
You have just started a new job and are thrilled to learn that your new employer offers a 401(k) retirement plan to its employees. Your annual salary is $40,000. Assume the IRS allows you to contribute up to $24,000 to your 401(k). You’ve decided to contribute 7% of your annual salary to the plan. Questions: How much more money would you need to contribute to meet the maximum allowable contribution set forth by the IRS? The company offers you a...
You and your friends have decided to take a trip after the semester ends to celebrate...
You and your friends have decided to take a trip after the semester ends to celebrate getting through your statistics class. Pick a departure point from a location that is close to your hometown (Denver, CO). You will find a list of ten different destinations for your trip below. ). So, you should have data for 12 different destination points. You need to collect some data online to find the distance between cities as well as the cost of airfare....
9. At the end of tax season, you and your friends go out to celebrate. Unfortunately,...
9. At the end of tax season, you and your friends go out to celebrate. Unfortunately, you enjoy the evening a bit too much and, on the way home, are pulled over by the police. After given a sobriety test, you are arrested for felony DUI. Do you report this incident to the board of accountancy? If not, under what circumstances are you required to do so?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT