# i need excel expert now have 2 tasks to do

Set the value of the January “Beg. Of Month Inventory” equal to the “Initial Inventory” cell. Use a formula with absolute addressing or a range name.

3. Set the value of January “Reclining Sofa Sales” equal to the “Initial Sales” cell. Use a formula with absolute addressing or a range name.

4. Set the value of January “Reclining Sofa New Arrivals” equal to the “Inventory Arrivals” cell. Use a formula with absolute addressing or a range name.

5. Management predicts that sales from Feb-June will increase by 5% each month. Using a formula, calculate this to reflect the correct “Reclining Sofa Sales” for each month. Use the ROUNDDOWN function to calculate sold items in each month.

6. Use the same formula to reflect “Reclining Sofa New Arrivals,” which are going to increase by 10% each month. Use the ROUNDDOWN function to calculate New Arrivals in each month.

7. Calculate “End of Month Inventory.”

8. For January, calculate “Reclining Sofa Retail Price” using “Reclining Sofa Cost” and “Reclining Sofa Markup.” Use a formula with absolute addressing or a range name.

9. Starting in February, calculate “Reclining Sofa Retail Price” incorporating the “Reclining Sofa Price Decrease.”

10. Calculate “Sales Revenue per Month.”

11. Calculate the “Total” cells using the SUM function.

12. Under “Goal Analysis” calculate using an IF statement function. If the “Sales Revenue per Month” is less than “Gross Margin Goal,” it should display “Not Met.” Otherwise, it should display “Met.” (Note: use a single IF statement.)

13. Complete the model.

14. Calculate the “Analysis” portion using the MAX, MIN, AVERAGE and COUNTIF functions.

15. Page Orientation Landscape; Create a header to include your name (center section), INFS 3100 Fall 2016 (right section), and Excel Assignment # 1 (left section). (Use the header menu option.)

16. Print a copy of your completed worksheet. (No row or column borders, e.g., A, B, C, 1, 2, 3)

17. Print a copy of your cell formulas. (To show formulas press: Ctrl ~ OR click: Formulas: Show Formulas on the toolbar)

Habilidades: Excel, Java, Powerpoint, SQL, Word

( 121 comentários ) Calcutta, India

ID do Projeto: #11621092

₹277 INR / hora
(0 Comentários)
0.0

## 9 freelancers estão ofertando em média ₹310/hora para esse trabalho

₹400 INR / hora
(112 Comentários)
5.5
tiaratechies

Hello, I am an expert and qualified person in excel as I am new to freelancer if given an opportunity will deliver the best in given time frame. Thank you & regards Techies

₹277 INR / hora
(22 Comentários)
4.1
₹388 INR / hora
(0 Comentários)
0.0
swatiagnani4u

hello, Dear Revered, we are the company who work for your benefit. we are the company where work comes first rather then anything else. we have developed many eCommerce websites. we are in this field of web de Mais

₹222 INR / hora
(0 Comentários)
0.0
₹277 INR / hora
(0 Comentários)
0.0
AMansoor88

Hi, Hope you will be doing good today. I have strong documentation skills, data search and analysis capability and good command on MS Office products. I can complete the task efficiently according to the desired Mais

₹277 INR / hora
(0 Comentários)
0.0
limyxuan29

A proposal has not yet been provided

₹111 INR / hora
(0 Comentários)
0.0
virtualdemon666

Hi, I would like to be considered for this assignment. I have a background as a data analyst and therefore have strong excel skills. I have also worked on a number of projects in the past working n large data sets w Mais

₹380 INR / hora
(0 Comentários)
0.0
jammukamal13

A proposal has not yet been provided

₹233 INR / hora
(0 Comentários)
0.0
mangalimac

I work as a Reports Analyst in a Telco Company. I have 4 years working experience using Excel application. If you want some Excel guy to help me. you can contact me here and I promise you will get a service you want.

₹277 INR / hora
(0 Comentários)
0.0