Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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 calculations

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Internal Auditing Basics Video Learning Guide

Authors: Charles A. Cianfrani & John E. West, James P. Gildersleeve

1st Edition

1891578251, 978-1891578250

More Books

Students also viewed these Accounting questions

Question

2. List your top 10 film villains.

Answered: 1 week ago