Suppose a Company Supplies Four of Its Products A, B

question 54

Essay

Suppose a company supplies four of its products A, B, C, and D, to five different regions. The management wanted to know the total number of all products supplied to each region and the total units of each product supplied. The data collected over a period of month are given below?Provide a data file?
ansrsource: The required data is provided below the question and we have been following this for all the completed chapters till date.
:
Provide a data file?
ansrsource: The required data is provided below the question and we have been following this for all the completed chapters till date.

There are several ways to get this information from the given data set. One way is to use the SUMIF function. The SUMIF function extends the SUM function by allowing the user to add the values of cells meeting a logical condition. The general form of the function is
=SUMIF(test range, condition, range to be summed)
Using the SUMIF function, find the total volume by each region and total volume by each product.

---

Definitions:

Transferred

The act of moving goods, costs, or funds from one account, location, or product to another.

Weighted-Average Method

A costing method where the cost of inventory items is determined based on the weighted average of the costs of similar items at the beginning of a period and the costs of items acquired during that period.

Work In Process

Units of product that are only partially complete.

Conversion Costs

Conversion costs represent the combined costs of direct labor and manufacturing overheads incurred to convert raw materials into finished goods.