Krupetskiy_Chapter2

Krupetskiy_Chapter2 - Exercise 2.33 Fred Hampel: 1. All of...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Exercise 2.33 Data input Supervisory and indirect labor $127,000 Supplies and indirect materials 14,000 Work-in-process inventory, January 1 135,000 Work-in-process inventory, Decembe 142,000 Administrative costs 304,000 Depreciation, manufacturing 103,000 Direct labor 482,000 Finished-goods inventory, January 1 160,000 Finished-goods inventory, December 147,000 Heat, light and power, plant 87,000 Marketing cost 272,000 Miscellaneous manufacturing cost 12,000 Plant maintenance and repairs 74,000 Raw materials purchases 313,000 Raw-material inventory, January 1 102,000 Raw-material inventory, December 3 81,000 Sales revenue 2,036,000 Manufacturing overhead costs Supervisory and indirect labor $127,000 Supplies and indirect materials 14,000 Depreciation, manufacturing 103,000 Heat, light and power, plant 87,000 Miscellaneous manufacturing cost 12,000 Plant maintenance and repairs 74,000 $417,000 Statement of Cost of Goods Manufactured and Sold Beginning WIP inventory Manufacturing costs added Direct material Beginning raw material invento $102,000 +Purchases of raw material 313,000 Fred Hampel: 1. All of the blue-filled cells a and table. Only change these problem or to perform "what problem in the textbook. 2. The unfilled cells should co outcomes using the data input cells should not contain nume references to the blue-filled ce data input as numerical parts opportunities for errors and b) That is, each time a data inpu have to find each use of that d cumbersome and prone to erro models.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
=Material available 415,000 - Ending raw material inventory 81,000 = Raw material used in production $334,000 Direct labor 482,000 Manufacturing overhead 417,000 Total manufacturing costs added Total cost in process Less ending WIP inventory Cost of goods completed Plus beginning finished goods Equals finished goods available for sale Less ending finished goods inventory Equals cost of goods sold Income Statement Sales revenue $2,036,000 Cost of goods sold $1,239,000 Gross margin 797,000 576,000 Operating income $221,000
Background image of page 2
Administrative costs $304,000 Marketing cost 272,000 $576,000 $135,000 are data input from the problem statement numbers if you want to change the t if" analysis. See Hints 1 and 2 for this contain formulas that calculate cell ut or previous calculations. (That is, these erical values; only formulas with cell cells above.) The solutions never repeat of formulas because this a) increases the b) reduces the flexibility of the analysis. ut is changed (see point #1), you would data input and change it. This is ror, especially with larger, more complex
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
1,233,000 1,368,000 142,000 1,226,000 160,000 1,386,000 147,000 ###
Background image of page 4
Exercise 2.38 Data input Merchandise inventory, Beginning $500,000 Merchandise inventory, Ending 300,000 Purchases 2,600,000 Transportation-in costs 260,000 Marketing and admin costs 1,600,000 Sales revenue 5,000,000 Statement of Cost of Goods Sold BB Beginning merchandise invent $500,000 TI + Purchases of merchandise
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 31

Krupetskiy_Chapter2 - Exercise 2.33 Fred Hampel: 1. All of...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online