# Is Case Study

Satisfactory Essays
394 Words
Grammar
Plagiarism
Writing
Score
Is Case Study
BA2800 Assignment 2
Case 1: Milligan’s Backyard Storage Kits
Due: July 18, 2011

Complete the case with these additional instructions:

1. Add the following columns: 2. Part 1 a. Annual Sales b. Annual COGS c. Annual Gross Profit d. Average Inventory Costs e. Gross Margin Ratio f. Markup g. Inventory Turnover h. Days in Inventory 3. Part 2 a. Gross Margin per Unit b. Percent of Sales

4. Provide the Average, High & Low for each applicable column 5. Add conditional formatting to each applicable column to highlight the high amount in green and the low amount in red. 6. Provide sum (totals) for a. Annual sales b. Annual COGS c. Annual gross profit d. Annual cost of average inventory 7. Add a report title 8. The two workbooks to be submitted via gateway. Workbook 2 is the workbook with the additional 6 items added) 9. The recommendation – answer memo/letter to be submitted via hardcopy 10. Answer Questions 1-9 (page 4) based on original data 11. Answer Questions 3-6 (page 5) based on original data plus the additional 6 items.

The assignment will be graded as follows Workbook 1 i. Formulas/Functions for cost of annual inventory, annual sales, cost of goods sold, annual gross profit, gross margin ratio, markup percentage, inventory turnover (8 points) ii. The average, minimum and maximum for the above calculations (9 points) iii. Totals formulas/functions for average inventory, annual gross profit, cost of goods sold and annual sales (4 points) iv. Headings, fit on one page, and decimal places consistent (6 points) v. Worksheets for items with less than 30% markup, lowest 5 items with annual sales in dollars, top 5 items with annual sales in dollars, lowest 5 items in quantity sales, top 5 items in

## You May Also Find These Documents Helpful

• Good Essays

| On the Toppings worksheet, display orange data bars with a gradient fill in all cells in the range A15:A29.…

• 566 Words
• 3 Pages
Good Essays
• Good Essays

Cushing’s syndrome is the term used to describe a group of symptoms that occur when a persons’ cortisol levels are too high (known as hypercortisolism) for too long. The majority of people have Cushing’s syndrome because they are regularly taking certain medicine(s) that continually add too much cortisol to the body. Doctors call this an “exogenous” (outside the body) cause of Cushing’s syndrome. Other people have Cushing’s syndrome because something is causing the adrenal gland(s) to overproduce cortisol.5 Doctors call this an “endogenous” (inside the body) cause of Cushing’s syndrome.…

• 1227 Words
• 5 Pages
Good Essays
• Satisfactory Essays

Review the following example on how to perform the inventory turnover calculation, which shows you how to complete the table.…

• 546 Words
• 3 Pages
Satisfactory Essays
• Good Essays

In the range B8:H16, create a two-variable data table. Set B3 as the row input cell, and B4 as the column input cell.…

• 566 Words
• 3 Pages
Good Essays
• Satisfactory Essays

a. Calculate purchases, gross margin, inventory turn days, accounts receivable turn days, and accounts payable turn days for the years ended 20x2, 20x3, 20x4, 20x5.…

• 512 Words
• 3 Pages
Satisfactory Essays
• Satisfactory Essays

Compute the April 30 inventory and the April cost of goods sold using the FIFO method.…

• 1420 Words
• 7 Pages
Satisfactory Essays
• Satisfactory Essays

## Final

• 1485 Words
• 19 Pages

2. Assuming a perpetual inventory system is used, use the following information to calculate cost of goods sold on an average-cost basis.…

• 1485 Words
• 19 Pages
Satisfactory Essays
• Powerful Essays

If you are not doing this assignment at Mt. SAC make sure you are using Excel 2007. You cannot use previous versions of Excel to complete this assignment. If you are doing this assignment in the lab, remember that you need a blue print card to use the lab printer.…

• 3306 Words
• 14 Pages
Powerful Essays
• Satisfactory Essays

Excel allows you to work with separate workbooks in a _____ and then link the workbooks to provide a consolidated view of the data in the workbooks. a. workspace c. presentation b. database d. document ANS: A PTS: 1 REF: EX 365 5. _____ often are used when creating an initial consolid ated worksheet to guide users of the worksheet regarding what type of data to enter in cells. a. Rows c. Placeholders b. Columns d. Titles ANS:…

• 503 Words
• 3 Pages
Satisfactory Essays
• Good Essays

5. If a company has beginning inventory of \$30,000 and ending inventory of \$55,000, compute its average inventory. If the cost of goods sold is \$140,000, compute its inventory turnover and determine how many days the average item is in stock. The average inventory would be 42,500, and average…

• 739 Words
• 3 Pages
Good Essays
• Powerful Essays

1.1 Identify what numerical and other information is needed in the spreadsheet and how it should be structured…

• 2272 Words
• 11 Pages
Powerful Essays
• Good Essays

These 3 tasks consists of a worksheet for P1 and two workbooks for P2 & P3…

• 1349 Words
• 6 Pages
Good Essays
• Satisfactory Essays

Selected Financial Data for Toyota Motors Corp., Inc. 2010-2014 (in 000s, YEN, expect per share amounts)(Automotive Segment)…

• 575 Words
• 13 Pages
Satisfactory Essays
• Good Essays

6. Display the last name and salary of employees who earn between \$5,000 and \$12,000 and are in department 20 or 50. Label the columns…

• 604 Words
• 3 Pages
Good Essays
• Powerful Essays

in 1964 and in 1973 the company was listed on the Athens S tock Exchange. In 1980…

• 10032 Words
• 41 Pages
Powerful Essays