? The Coco Lamela Company (CLC) owns the global rights to sell a very fragile glass ornament
Fantastic news! We've Found the answer you've been seeking!
Question:
?
Transcribed Image Text:
The Coco Lamela Company (CLC) owns the global rights to sell a very fragile glass ornament called "Jack Wilshere's Tears". The cost of goods sold for the ornaments are shown on the second page. CLC sets its selling prices so that each unit sold returns a seventy-five percent gross margin. Data regarding product costs, and administration and selling expenses for the past twelve months have been accumulated in order develop a budget estimate for an upcoming month. Coco Lamela's Marketing Department has reviewed this data and could not reach a conclusion as to what is the most appropriate independent variable for predicting variable and mixed costs. These costs may be dependent on labor hours, unit sales, or distance shipped - Marketing just doesn't know since they never had to take this accounting course. It is up to you to figure this out. REQUIRED: A. Get the information from the second page into your Excel workbook. Analyze the data to determine the behavior of each cost. The variable and mixed costs may be dependent on labor hours, unit sales, or distance shipped. Use Excel's RSQ function to determine what is the cost driver for variable component of those costs that are variable or mixed. Once the cost driver is determined for each of the mixed or variable costs you will need to determine the cost elements using the Excel SLOPE and INTERCEPT functions. B. C. The Coco Lamela Company wants to estimate profitability for the upcoming month. The following estimates are to be used: unit sales: 67,000; total labor hours worked: 97,000 hours; distance shipped: 347,000 miles. First, prepare a pro forma Contribution Format Income Statement for the upcoming month. Next, construct a Traditional Income Statement for the upcoming month. Make certain to present each cost/expense item separately on its own line - do not aggregate the costs. Regarding the selling price; this should first be calculated on a per unit basis, then use the ROUND function to limit this amount to a whole dollar amount. The Coco Lamela Company (CLC) owns the global rights to sell a very fragile glass ornament called "Jack Wilshere's Tears". The cost of goods sold for the ornaments are shown on the second page. CLC sets its selling prices so that each unit sold returns a seventy-five percent gross margin. Data regarding product costs, and administration and selling expenses for the past twelve months have been accumulated in order develop a budget estimate for an upcoming month. Coco Lamela's Marketing Department has reviewed this data and could not reach a conclusion as to what is the most appropriate independent variable for predicting variable and mixed costs. These costs may be dependent on labor hours, unit sales, or distance shipped - Marketing just doesn't know since they never had to take this accounting course. It is up to you to figure this out. REQUIRED: A. Get the information from the second page into your Excel workbook. Analyze the data to determine the behavior of each cost. The variable and mixed costs may be dependent on labor hours, unit sales, or distance shipped. Use Excel's RSQ function to determine what is the cost driver for variable component of those costs that are variable or mixed. Once the cost driver is determined for each of the mixed or variable costs you will need to determine the cost elements using the Excel SLOPE and INTERCEPT functions. B. C. The Coco Lamela Company wants to estimate profitability for the upcoming month. The following estimates are to be used: unit sales: 67,000; total labor hours worked: 97,000 hours; distance shipped: 347,000 miles. First, prepare a pro forma Contribution Format Income Statement for the upcoming month. Next, construct a Traditional Income Statement for the upcoming month. Make certain to present each cost/expense item separately on its own line - do not aggregate the costs. Regarding the selling price; this should first be calculated on a per unit basis, then use the ROUND function to limit this amount to a whole dollar amount.
Expert Answer:
Answer rating: 100% (QA)
The following data is given The Selling Price is Determined to give 75 Gross Margin Months Distannce ... View the full answer
Posted Date:
Students also viewed these accounting questions
-
Since the early 1990s, woodstove sales have declined from 1,200,000 units per year to approximately 100,000 units per year. The decline has occurred because of (1) stringent new federal EPA...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Natalie Warren is a single woman in her late 20s. She is renting an apartment in the fashionable part of town for $1,300 a month. After much thought, she's seriously considering buying a condominium...
-
A city is having scal problems in 2015. It expects to report a decit in its general fund, the only fund that is statutorily required to be balanced. To eliminate the anticipated decit the city opts...
-
How is the calculation of taxable income for an individual different from the calculation of a corporation's taxable income?
-
The CN Railroad is considering replacement of a Montreal Power Jack Tamper, used for maintenance of track, with a new automatic raising device that can be attachedto a production tamper. The present...
-
Aaron Company, which has only one product, has provided the following data concerning its most recent month of operations: Selling price ...........................................$90 Units in...
-
23. A triangular corner of a store has been roped off to be used as an area for displaying Christmas ornaments. Find the area of the display section. 24 ft
-
For this exercise, we use JTRAIN.RAW to determine the effect of the job training grant on hours of job training per employee. The basic model for the three years is hrsempit = (0 + (1td88t + (2d89, +...
-
The following information has been extracted from a bank based on New York and the central banks of USA and Switzerland. Spot exchange rate SFr1.2251/$ Six-month forward exchange rate SFr1.1922/$ ...
-
The following formula is to determine the preliminary estimate of the sample size for difference estimation considering only Beta risk: Define each of the terms affecting sample size and state the...
-
What would you do to minimize the abuse of FMLA leave if you became the HR manager in a company in which abuse was rampant? Explain how your answer would help overcome the problem.
-
A 5%, 10-year bond was issued at a price of 94. Requirement 1.Was the market interest rate at the date of issuance closest to 4%, 5%, or 6%? Explain.
-
How would you lower your companys experience rating in the areas of workers compensation and unemployment insurance if you were the HR manager?
-
Assume that on October 1, 2011, Big Company borrowed \(\$ 10,000\) from the local bank at 6 percent interest. The note is due on October 1, 2012. How much interest does Big pay in 2011? How much...
-
1. An overview of a firm's cost of debt The is the interest rate that a firm pays on any new debt financing. Cold Goose Metal Works (CGMW) can borrow funds at an interest rate of 7.30% for a period...
-
What are the main distinctions between the different schools of legal interpretation?
-
Visit SunGards web site, http://www.sungard.com, and research its recovery services offered for the following classes: High Availability, System Recovery, and End-User Recover. Write a report of your...
-
Micro Systems, a developer of database software packages, is a publicly held company and listed with the SEC. The company has no internal audit function. In complying with SOX, Micro Systems has...
-
Leigh Industries has an internal audit department consisting of a director and four staff auditors. The director of internal audit, Diane Bauer, reports to the corporate controller, who receives...
Study smarter with the SolutionInn App