Exercise 1) Complete the following Excel Assignment and submit it to dropbox: Sales increase: 22% Cost...

Exercise 1) Complete the following Excel Assignment and submit it to dropbox:

Sales increase: 22%

Cost of Sales: 33%

Ending Inventory Needs:

Q1, 2021 Expected Sales: $696,000

Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Q1 2021

Sales in 2019 $407,000 $455,000 $505,000 $778,000 $2,145,000

Expected Sales 2020 xxx xxx xxx xxx xxx xxx

Cost of Sales xxx xxx xxx xxx xxx xxx

Beginning Inventory xxx xxx xxx xxx xxx xxx

Ending Inventory xxx xxx xxx xxx xxx xxx

Purchases xxx xxx xxx xxx xxx xxx

Instructions:

Redo this table, putting formulas in all cells that have the "xxx". For this exercise, assume that sales will increase by 22% over 2019. Cost of sales equals 33% of sales. Ending inventory should equal 44% of the amount needed for next quarter sales. Expected sales in the 1st quarter of 2021 will be $696,000. Make sure that all formulas will adjust for changes in the assumptions noted inside the box. Round all answers to whole numbers (no decimals).

Solutions

Expert Solution

Answer is given below with excel formulas. please link the cells

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

This assignment is to be completed in Excel. When completed, submit the exercise by the due...

This assignment is to be completed in Excel. When completed, submit the exercise by the due date in Blackboard (BB) and Attach a copy of the excel spreadsheet. Case Narrative: Ann E. Belle is age 42 and plans to retire in 25 years (at age 67). She has retirement savings in a mutual fund account, which has a current balance of $100,000 (Ann does not plan to add any additional money to this account). Also, Ann opened a 401K retirement...

This assignment is to be completed in Excel. When completed, submit the exercise by the due...

This assignment is to be completed in Excel. When completed, submit the exercise by the due date in Blackboard (BB) and Attach a copy of the excel spreadsheet. Case Narrative: Susan Smith is age 45 and plans to retire in 15 years (at age 60). She has retirement savings in a mutual fund account, which has a current balance of $250,000 (Susan does not plan to add any additional money to this account). Also, Susan opened a 401K retirement account with...

For this assignment, please submit the answers to the following questions, as well as an Excel...

For this assignment, please submit the answers to the following questions, as well as an Excel spreadsheet which documents the work you did. Do poets die young? According to William Butler Yeats, “She is the Gaelic muse, for she gives inspiration to those she persecutes. The Gaelic poets die young, for she is restless, and will not let them remain long on earth.” One study designed to investigate this issue examined the age at death for writers from different cultures...

Assignment 1 Note: submit the following 1- "Excel file" include data and graph and analysis "please...

Assignment 1 Note: submit the following 1- "Excel file" include data and graph and analysis "please do not use anything rather than excel" 2- a functional code that performs all the required operations in 1 & part A 1-Collect set of data from the web. About coronavirus evolution in different countries considering other factors like median age of populations, health care systems etc. you are required to perform statistical analysis of this data by calculating the different statistical metrics (like...

Use Excel to complete the following question. You must submit/attach all work done in Excel in...

Use Excel to complete the following question. You must submit/attach all work done in Excel in order to receive full credit. 5. A health advocacy group conducted a study to determine if the nicotine content of a particular brand of cigarettes was equal to the advertised amount. The cigarette brand advertised that the average nicotine content per cigarette was 1.4 milligrams. The advocacy group randomly sampled 24 cigarettes. The nicotine level for each of the sampled cigarettes is given below....

Please use Excel to solve the assignment and submit as an excel spreadsheet. Bethesda Mining Company...

Please use Excel to solve the assignment and submit as an excel spreadsheet. Bethesda Mining Company Based on a Mini Case presented in the textbook Ross, S.A., R.W. Westerfield and J. Jaffe, Corporate Finance, McGraw Hill/Irwin. Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the...

Part 1: The Unemployment Rate (weight 30% of the assignment grade) Complete the following exercise Visit...

Part 1: The Unemployment Rate (weight 30% of the assignment grade) Complete the following exercise Visit the Bureau of Labor Statistics Web Site, www.bls.gov/news.release/empsit.toc.htm . Select Employment Situation Summary. Write a report (1-2 pages double - spaced) to answer the questions: What month (and year) is summarized? What was the unemployment rate for that month? How does that rate compare with the rate in the previous month? What were the unemployment rates for adult women, teenagers, blacks, Hispanics, and whites?...

To complete this comprehensive exercise, use the Excel spreadsheet program. In this exercise you will be...

To complete this comprehensive exercise, use the Excel spreadsheet program. In this exercise you will be using linear programming and Solver in Excel to solve the problem described in the following scenario. At Goodman Shipping, the load master wants to determine the mix of cargo to be carried on the next trip. The ship's volume limit for cargo is 100,000 cubic meters, and its weight capacity is 2,310 tons. The master has five different types of cargo from which to...

Assignment Exercise 23–1: Cost of Owning and Cost of Leasing Cost of owning and cost of...

Assignment Exercise 23–1: Cost of Owning and Cost of Leasing Cost of owning and cost of leasing tables are reproduced below. Required Using the appropriate table from the Chapter 13 Time Value of Money Appendices appearing as 13-A, 13-B, and 13-C, record the present-value factor at 10% for each year and compute the present-value cost of owning and the present value of leasing. Which alternative is more desirable at this interest rate? Do you think your answer would change if...

Please finish the following assignment in Excel Does price affect sales? Does Advertising affect sales? Are...

Please finish the following assignment in Excel Does price affect sales? Does Advertising affect sales? Are there any interaction effects between price and advertising? Show it with graph. Price Low Medium High Low 41 21 15 Adv 25 20 14 23 16 13 Medium 28 28 14 30 22 13 32 18 12 High 50 34 13 51 40 13 52 32 13

Subjects