Scribd
Upload
4 views2 pages

Homework 4

The document outlines five homework problems for an MBA course, each focusing on calculating final revenue for different businesses using VLOOKUP and HLOOKUP functions. The problems cover a range of industries including organic produce, electronics retail, SaaS platforms, logistics, and media production, with specific tasks related to pricing and discount applications. Each problem includes background information and data requirements for revenue calculation.

Uploaded by

Parth Patel
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views2 pages

Homework 4

The document outlines five homework problems for an MBA course, each focusing on calculating final revenue for different businesses using VLOOKUP and HLOOKUP functions. The problems cover a range of industries including organic produce, electronics retail, SaaS platforms, logistics, and media production, with specific tasks related to pricing and discount applications. Each problem includes background information and data requirements for revenue calculation.

Uploaded by

Parth Patel
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

MSC 517 Homework 4 Prof.

Panchal
MBA 504/MAX 502 Spring 2026
Problem 1: GreenSprout Organics – Discounted Revenue

Background:

GreenSprout Organics is a regional supplier specializing in fresh organic produce, including leafy greens, root
vegetables, citrus fruits, berries, and organic dairy. Sheet1 shows per-kg pricing and volume-based discount tiers
tied to order size, along with customer orders from grocers, restaurants, and markets.

Task:

Using the data on this sheet, obtain the final revenue result by applying VLOOKUP for the correct price/rate and
HLOOKUP for the appropriate discount.

Problem 2: Electronics Retail – Net Revenue

Background:

The electronics retailer operates in a competitive wholesale environment, supplying smartphones, laptops,
tablets, monitors, and accessories. Sheet2 shows per-unit pricing with unit-based discount breakpoints, and
customer orders from various retail chains with differing order volumes.

Task:

Using the data on this sheet, obtain the final revenue result by applying VLOOKUP for the correct price/rate and
HLOOKUP for the appropriate discount.

Problem 3: SaaS Platform – Monthly Revenue

Background:

This SaaS platform provides tiered subscription services—Starter, Pro, Business, and Enterprise—priced per seat
with seat-count discount bands. Sheet3 lists client companies with varying seat deployments requiring monthly
revenue calculation.

Task:

Using the data on this sheet, obtain the final revenue result by applying VLOOKUP for the correct price/rate and
HLOOKUP for the appropriate discount.
Problem 4: Logistics Firm – Net Revenue

Background:

The logistics firm offers ground, air, and refrigerated freight services. Sheet4 provides shipment-based rates and
discount tiers linked to shipment volume, along with client shipment orders across industries.

Task:

Using the data on this sheet, obtain the final revenue result by applying VLOOKUP for the correct price/rate and
HLOOKUP for the appropriate discount.

Problem 5: Media Studio – Project Revenue

Background:

The media studio provides editing, recording, full-production, and animation services. Sheet5 shows per-project
pricing and asset-count discount levels, along with client project listings of varying sizes and complexity.

Task:

Using the data on this sheet, obtain the final revenue result by applying VLOOKUP for the correct price/rate and
HLOOKUP for the appropriate discount.

You might also like