Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show how to do each step. On Excel if possible George has set up a jewelry production company. The company specialized in making diamond
Please show how to do each step. On Excel if possible
George has set up a jewelry production company. The company specialized in making diamond rings. Last year he engaged a public accounting firm that completed a financial audit. The auditor recommended that George should set up a process cost-accounting system to better forecast and control expenses. He has done this; however, he is not happy with the results. George has reached out to you to help him better understand why the process cost accounting is not working. He gives you the following information for July: George states that the company buys wholesale lots of diamonds, but they vary in weight. His diamond supplier charges strictly on weight, with heavier diamonds costing more. George uses stones anywhere from .951.05ct in weight. It is not possible for him to order stones in a tighter weight range than this. Gold is used commensurate with the size of the ring, larger rings needing more gold. George fills orders based on requested size. He is disappointed that his costing system does not appear to help him run a better controlled business. He has contracted you, as a professional managerial accountant, to help him run his business better. 1. For each item listed determine if it is fixed or variable. Remember: fixed means it does not change over the relevant range. Calculate the contribution margin and monthly profit/loss based on projected and actual numbers. Show all calculations in full detail with every line, revenue and expense labelled. 2. Based on George's projections what is the break-even level of rings sold. Show all calculationsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started