• At the end of the month, 10 percent of the materials purchased remained on hand, work in process amounted to 20 percent of the manufacturing costs incurred during the month, and finished goods inventories were negligible.
• The factory occupies 80 percent of the premises, the sales area 15 percent of the premises and the rest of the premises is occupied by the administrative functions
• Equipment in the factory accounted for 95 percent of the total book value of equipment, with 5 percent of the equipment book value being used for sales and administrative functions.

Almost all the electricity is consumed in the factory.

The truck is used to deliver finished goods to customers.

Kasper Muthu spends about one-half of his time on factory management, one-third in the sales area and the rest on administration.

REQUIRED:

Using Excel, estimate the cost of goods manufactured revised statement of financial performance for the month.