? 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...
-
Yee gave Woo three checks for a total amount of $ 124,600. Yee died before Woo could cash them. Woo cashed two of the checks after Yee died and made a claim against Yees estate for the amount...
-
What is meant by the term generally accepted accounting principles? What is the significance of the phrase generally accepted?
-
A toroid has 250 square windings carrying a current of \(3.0 \mathrm{~mA}\). Each side of each square winding is \(50 \mathrm{~mm}\) long, and the distance from the toroid center to the inner surface...
-
Audio Mechanics, Inc. manufactures two models of speakers, DL and XL. Based on the following production and sales data for September 2012, prepare(a) A sales budget and(b) A production budget. XL DL...
-
7. 8. The work done by a gas molecule in an isolated system is given by W=ae KT, where x is the displacement, k is the Boltzmann constant and T is the temperature. and are constants. Then the...
-
Neal Co. allocates overhead cost using a single plantwide overhead rate of \$20 per direct labor hour. Each product unit uses three direct labor hours. Compute the overhead cost per unit.
-
The auditorium in High school has 25 seats in the first row, 29 seats in the second row, 33 seats in the third row and so on in an arithmetic sequence. Determine the number of seats in each of the...
-
The lengths in minutes of each of the flights between San Francisco and Atlanta in the past month. State whether the data described are discrete or continuous and explain why?
-
Find the Nielsen ratings for the past week. What were the three most popular television shows? Explain the meaning of the rating and the share for each show.
-
The times required by students to complete a statistics test. State whether the data described are discrete or continuous and explain why?
-
The exact amounts of cola in different cans Levels of Measurement. State whether the data described are discrete or continuous and explain why?
-
The weights of checked bags on flights between San Francisco and Atlanta. State whether the data described are discrete or continuous and explain why?
-
Imagine you are a digital marketer for an online retailer selling expensive audio equipment. You want to conduct a promotional campaign, in which people are offered the chance to win back the total...
-
The Dow Jones Industrial Average reached a high of $ 7801.63 on December 29, 1997. Recall from Example 18.4 that it reached a high of $ 1003 on November 14, 1972. The Consumer Price Index for...
-
Lets suppose that a vertebrate organism carries a mutation that causes some cells that normally differentiate into nerve cells to differentiate into muscle cells. A molecular analysis reveals that...
-
Briefly describe three ways that ATP-dependent chromatinremodeling complexes may change chromatin structure.
-
Beginning with the binding of an activator protein at a nucleosome-free region, describe the steps that occur when a eukaryotic gene is transcribed.
Study smarter with the SolutionInn App