Devry BIAM400 All Chapters Homework Except Week 7 and 8 Latest 2023 May

BIAM400 

Week 1 Excel Homework

After reviewing this week’s lesson, attached is your homework where you will create 3 spreadsheets.  You can use one workbook and create 3 sheets within the book. Label them Q1, Q2, and Q3.  BIAM400_Week 1_Homework-1.pdf Download BIAM400_Week 1_Homework-1.pdf

The assignment focuses on the following:

Q1:  Calculating SUMPRODUCT

Q2:  Determining Break Even Analysis

Q3:  Calculating Average

Don’t forget to submit your assignment.

BIAM 400 WEEK 1 HOMEWORK

1. CALCULATE SUMPRODUCT

Build an Excel spreadsheet with the following data:

Item Planned Sold

Apples $285 $285

Apples $320 $310

Lemons $280 $280

Oranges $335 $335

Apples $280 $260

Apples $250 $250

Lemons $255 $230

Apples $255 $270

Apples $280 $280

Calculate the following using SUMPRODUCT:

All Items: Sold < Planned ________________

Apples: Sold < Planned ________________

2. BREAK-EVEN ANALYSIS

Use an excel spreadsheet to solve the following problem. Make sure to use variable

costs and fixed cost appropriately. You have been asked to perform a break-even

analysis on the summer art camp. You need to determine how many students must

attend in order for the camp to break-even this summer. Setup an Excel spreadsheet

with the data below and use the goal seek option in Excel to determine your answer.

Submit the Excel spreadsheet for this assignment.

Camp Price: $310.00

Costs Per Student:

Cleanup: $12.00

Paint: $25.00

Food: $150.00

Camp Expenses:

Bus Trip to Art Museum: $2,000.00

Administrative: $1,000.00

Miscellaneous: $100.00

3. MID YEAR AVERAGE

Dave has a challenge. Below are his monthly sales amounts for the first half of the year.

If he reaches a $200,000mid-year average, he will receive a 5% bonus. Use Goal Seek to

find how much he needs to sell in June to make the $200,000 average. Create an Excel

worksheet with the following data to answer the question of how much he needs to sell

in June to make the $200,000 average:

Month Sales

January $157,274.00

February $187,349.00

March $179,291.00

April $202,025.00

May $212,685.00

June

Mid-Year

Average

 

 

Week 2: Chapter 2 Homework

Week 2 Homework Templates

BIAM400 Wk2-Q1 Template

BIAM400Wk2-Q2-Template

BIAM400-Week 2-Q3-Template

 

 

Week 3: Chapter 3 Homework

Week 3 Homework Templates

BIAM400 Wk3-Q1 Template

BIAM400Wk3-Q2-Template

BIAM400-Week 3-Q3-Template

 

 

Week 4: Chapter 5 Homework

BIAM400 Week 4 Q1-Assignment Template

BIAM400 Week 4 Q2-Assignment Template

BIAM400 Week 4 Q3-Assignment Template

 

 

Week 5: Chapter 9 Homework

Week 5 Homework Templates

BIAM400 Week 5 Q1 Assignment Template

BIAM400 Week 5 Q2 Assignment Template

BIAM400 Week 5 Q3 Assignment Template

 

Week 6: Chapter 10 Homework

Week 6 Homework Templates

BIAM400 Week 6 Q1-Assignment Template

BIAM400 Week 6 Q2-Assignment Template

BIAM400 Week 6 Q3-Assignment Template