Question

In: Accounting

The following data are for Milton Department Store. The account balances​ (in thousands) are for 2014....

The following data are for Milton Department Store. The account balances​ (in thousands) are for 2014.

​(Click the icon to view the account​ balances.)

Requirements

1.

Compute ​(a) the cost of goods purchased and ​(b) the cost of goods sold.

2.

Prepare the income statement for2014

Requirement 1. Compute ​(a) the cost of goods purchased and ​(b) the cost of goods sold.

a) Calculate the cost of goods purchased by completing the schedule. ​(Leave any unused cells​ blank.)

Milton Department Store

Schedule of Cost of Goods Purchased

For the Year Ended December 31, 2014 (in thousands)

Add:

Deduct:

Cost of goods purchased

TABLE

Marketing, distribution, and customer-service costs

$32,000

Merchandise inventory, January 1, 2014

25,000

Utilities

19,000

General and administrative costs

45,000

Merchandise inventory, December 31, 2014

34,000

Purchases

153,000

Miscellaneous costs

3,000

Transportation-in

7,000

Purchase returns and allowances

5,000

Purchase discounts

9,000

Revenues

315,000

Solutions

Expert Solution

a) Calculate the cost of goods purchased by completing the schedule.

Purchases 153000
Add: Transportation int 7000
Less: Purchase returns and allowances (5000)
Less: Purchase discounts (9000)
Cost of goods purchase 146000

Calculate cost of goods sold :

Cost of goods sold = Beginning inventory+cost of goods purchase-ending inventory

                             = 25000+146000-34000

Cost of goods sold = 137000

Prepare income statement

Revenue 315000
Less: Cost of goods sold (137000)
Gross profit 178000
Less: Expenses
Marketing, distribution, and customer-service costs (32000)
Utilities (19000)
General and administrative costs (45000)
Miscellaneous costs (3000) (99000)
Net operating income 79000

Related Solutions

Consider the following account balances in thousands for the Yankee Company for the year ended December...
Consider the following account balances in thousands for the Yankee Company for the year ended December 31, 2017: Direct Materials Inventory, Beginning                  $          24,000 Direct Material Invenotry, Ending                                    26,000 Work in Process, Beginning                                           32,000 Work in Process, Ending                                               14,000 Finished Goods Inventory, Beginning                              25,000 Finished Goods Inventory, Ending                                  18,000 Direct Materials, Purchased                                           99,000 Direct Labor                                                                  30,000 Indirect Labor                                                                12,000 Plant insurance                                                              9,000 Other insurance                                                             8,000 Depreciation – plant                                                      11,000 Depreciation – other                                                      10,000 Repairs & Maintenance – plant                                       5,000 Marketing...
Multiple statements. The following are account balances (in thousands) at September 30, 20X1, for Upper Merion...
Multiple statements. The following are account balances (in thousands) at September 30, 20X1, for Upper Merion Hospital. Prepare (a) a balance sheet, (b) a statement of opera- tions, and (c) a statement of changes in net assets for September 30, 20X1. Givens (in ’000s) Provision for bad debt-23,800, Cash -30,000,Patient revenue (net of contractuals-275,00, Net accounts receivable -42,100,Ending balance, temporarily restricted net assets -15,900,Wages payable-6,500, Inventory-2,800, Long-term debt-143,000, Supply expense-55,000, Gross plant, property, and equipment -290,000,Net assets released from temporary...
Consider the following account balances (in thousands) for the Canseco companies: Beginning Ending Direct materials inventory...
Consider the following account balances (in thousands) for the Canseco companies: Beginning Ending Direct materials inventory $500,000 $875,000 Work-in-process inventory 125,000 250,000 Finished-goods inventory 250,000 625,000 Purchases of direct materials 1,250,000 Direct manufacturing labor 1,625,000 Indirect manufacturing labor 150,000 Plant insurance 65,000 Depreciation—plant, building, and equipment 185,000 Plant utilities 105,000 Repairs and maintenance—plant 95,000 Equipment leasing costs 352,500 Miscellaneous Plant Costs 35,000 Plant Utilities 75,000 Marketing, distribution, and customer-service costs 575,000 General and administrative costs 425,000 Prepare a schedule for...
Xmet Inc. showed the following alphabetized list of adjusted account balances at December 31, 2014:   ...
Xmet Inc. showed the following alphabetized list of adjusted account balances at December 31, 2014:      Accounts Payable 26,160   Accounts Receivable 39,600   Accumulated depreciation, Equipment 10,840   Accumulated depreciation, Warehouse 21,680   Cash 8,800   Cash Dividends 20,000   Common Shares 116,000   Equipment 78,800   Income Tax Expense 41,000   Land 121,600   Notes Payable, due in 2017 34,000   Operating Expenses 109,600   Preferred Shares 39,600   Retained Earnings 28,120   Revenue 275,800   Warehouse 132,800    Required: 1. Assuming normal balances, prepare the closing entries at December 31, 2014, the...
The following data relate to the Machinery account of Eshkol, Inc. at December 31, 2014. Machinery...
The following data relate to the Machinery account of Eshkol, Inc. at December 31, 2014. Machinery A B C D Original cost $63,480 $70,380 $110,400 $110,400 Year purchased 2009 2010 2011 2013 Useful life 10 years 15,000 hours 15 years 10 years Salvage value $4,278 $4,140 $6,900 $6,900 Depreciation method Sum-of-the-years'-digits Activity Straight-line Double-declining balance Accum. depr through 2014* $43,056 $48,576 $20,700 $22,080 *In the year an asset is purchased, Eshkol, Inc. does not record any depreciation expense on the...
The following data are monthly sales of jeans at a local department store. The buyer would...
The following data are monthly sales of jeans at a local department store. The buyer would like to forecast sales of jeans for the next month, July. (a) Forecast sales of jeans for March through June using the naïve method, a two-period moving average, and exponential smoothing with an ? = 0.2. (Hint: Use naïve to start the exponential smoothing process.) (b) Compare the forecasts using MAD and decide which is best. (c) Using your method of choice, make a...
Write a program that uses a structure to store the following data about a customer account:...
Write a program that uses a structure to store the following data about a customer account: Name Address City, State and Zip Telephone number Account balance Date of last payment The program should use an array of at least 5 structures. It should let the user enter data into the array, change the contents of any element and display all the data stored in the array. The program should have a menu-driven interface and use functions as appropriate. Input validation:...
Listed below are year-end, 12/31/21, account balances ($ in thousands) taken from the records of XYZ...
Listed below are year-end, 12/31/21, account balances ($ in thousands) taken from the records of XYZ Corporation. XYZ Corporation Adjusted Trial Balance December 31, 2021 Debit Credit Accounts receivable       700 Building 480 Equipment 375 Cash 125 Inventory 90 Land 300 Notes receivable 530 Investments 330 Prepaid rent (for the next 2 years) 50 Supplies 20 Trademark 50 Prepaid Insurance (for the next 3 years) 90 Accounts payable      620 Accumulated depreciation- Equipment 225 Accumulated depreciation- Buildings 180 Total stockholders' equity...
Listed below are year-end, 12/31/21, account balances ($ in thousands) taken from the records of XYZ...
Listed below are year-end, 12/31/21, account balances ($ in thousands) taken from the records of XYZ Corporation. XYZ Corporation Adjusted Trial Balance December 31, 2021 Debit Credit Accounts receivable       700 Building 480 Equipment 375 Cash 125 Inventory 90 Land 300 Notes receivable 530 Investments 330 Prepaid rent (for the next 2 years) 50 Supplies 20 Trademark 50 Prepaid Insurance (for the next 3 years) 90 Accounts payable      620 Accumulated depreciation- Equipment 225 Accumulated depreciation- Buildings 180 Total stockholders' equity...
Part (a) using the data set below on the account balances of customers at a bank’s...
Part (a) using the data set below on the account balances of customers at a bank’s four locations. Using that data set and an α of 0.05, test the null hypothesis that the mean account balances are equal in the four towns using a one-way ANOVA in Excel. using Excel file include the output as part of the answer. Part (b)    Do you reject the null hypothesis or not? Indicate on which part of the Excel output you base...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT