Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the following information to answer the following questions, using the SUMPRODUCT function. Stone Age Surfboards is a small manufacturer of two types of popular

Use the following information to answer the following questions, using the SUMPRODUCT function.

Stone Age Surfboards is a small manufacturer of two types of popular high-tide surfboards, the Rockwell and the Limestone models. The manufacturing process consists of two departments: fabrication and finishing. The fabrication department has 15 skilled workers, each of whom works 5 hours per day. The finishing department has 5 workers, who also work a 5-hour shift. Each pair of Rockwell surfboards requires 3 labor-hours in the fabrication department and 1.5 labor-hours in finishing. The Limestone model requires 4.5 labor-hours in the fabrication department and 2 labor-hours in finishing. The company operates 6 days a week. It makes a per-unit profit of $60 on the Rockwell model and $75 on the Limestone model. Approximately 4.1 Rockwell models and 8.4 Limestone models are produced per day.

A B C D
1 Stone Age Surfboards
2
3 Data
4 Product
5 Department Rockwell Limestone Limitation (hours)
6 Fabrication 3 4.5 75
7 Finishing 1.5 2 25
8
9 Profit/Unit $60 $75
10
11
12 Model
13 Rockwell Limestone
14 Quantity Produced 4.1 8.4 Hours Used
15 Fabrication
16 Finishing
17
18 Excess Limestone
19 Market Mixture
20
21 Total Profit
22 Profit Contribution

What is the total profit generated?

A. $480.50
B. $675.50
C. $876.00
D. $965.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Food And Beverage Cost Control

Authors: Jack E. Miller, Lea R. Dopson, David K. Hayes

3rd Edition

0471273546, 978-0471273547

More Books

Students also viewed these Accounting questions