Walton Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventorypurchases budget. Walton's policy is to maintain an ending inventory balance equal to 20 percent of the following month's cost ofgoods sold. April's budgeted cost of goods sold is $78,000.Requireda. Complete the inventory purchases budget by filling in the missing amounts.b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement.c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter.Complete this question by entering your answers in the tabs below.Req AReq B and CDetermine the amount of cost of goods sold the company will report on its first quarter pro forma income statement.Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the firstquarter.b.Cost of goods soldC.Ending inventory< Req AReg B and C > HomeworkSavedHelpWalton Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventorypurchases budget. Walton's policy is to maintain an ending inventory balance equal to 20 percent of the following month's cost ofgoods sold. April's budgeted cost of goods sold is $78,000.Requireda. Complete the inventory purchases budget by filling in the missing amounts.b. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement.c. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter.Complete this question by entering your answers in the tabs below.Req AReq B and CComplete the inventory purchases budget by filling in the missing amounts.Inventory Purchases BudgetJanuaryFebruaryMarchBudgeted cost of goods sold54,000$58,000 $64,00011,600Inventory needed65,60010,800Required purchases (on account)2$54,800

A financial plan that reports the total estimated costs or units of item inventory that are expected…

Answered: Walton Company sells lamps and other…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Carmen Company sells jar candles. The sales forecast (units) for the coming months is: April 210 May 140 June 150 July 200 August 160 Each candle costs $ 10. The ending inventory policy is 40% of next month's sales needs. April 1 inventory will be as expected under the policy. Carmen pays for purchases 30% in the month of purchase and 70% the following month. Accounts payable on April 1 is $2,460. Required: a. Prepare a purchases budget for the quarter ending June 30. Note: Deductible values must be indicated with a minus sign.a. Prepare a purchases budget for the quarter ending June 30. Note: Deductible values must be indicated with a minus sign. b. Prepare a cash payments budget for the quarter ending June 30.
Summit Company has budgeted purchases of merchandise inventory of $457,500 in January and $533,750 in February. Assume Summit pays for inventory purchases 40% in the month of the purchase and 60% in the month after purchase. The Accounts Payable balance on December 31 is $97,350. Prepare a schedule of cash payments for purchases for January and February. Cash Payments January February Total merchandise inventory purchases Cash Payments Merchandise Inventory: Dec.—Dec. 31 Accounts Payable, paid in Jan. Jan.—Jan. merchandise inventory purchases paid in Jan. Jan.—Jan. merchandise inventory purchases paid in Feb. Feb.—Feb. merchandise inventory purchases paid in Feb. Total payments for merchandise inventory
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
The following is a schedule of the projected unit sales of Western Company, which manufactures casual wear. Each unit sells for $25. The company began the period with a beginning accounts receivable balance of $10,000. Choose the correct answer from the options provided. Budgeted unit sales Percentage of sales collected in the quarter of the sale Percentage of sales collected in the quarter after the sale. Quarter First Second Third Fourth 1,500 1,300 1,400 1,300 Knowledge Check 01 What is the amount of budgeted sales revenue for the fourth quarter? O $32,500 $33,750 O $35,000 $37,500 $8,125 O $8,750 O $9,375 O $28,125 Year 5,500 75% 25% Knowledge Check 02 What is the amount of cash that is expected to be collected during the second quarter as a result of sales made during the first quarter?
Metro, Incorporated sells backpacks. The Company's accountant is preparing the purchases budget for the first quarter operations. Metro maintains ending inventory at 15% of the following month's expected cost of goods sold. Expected cost of goods sold for April is $78,000. All purchases are made on account with 30% of accounts paid in the month of purchase and the remaining 70% paid in the month following the month of purchase. Sales January $ 44,000 February $ 58,000 Budgeted cost of goods sold Plus: Desired ending inventory Inventory needed Less: Beginning inventory March $ 64,000 8,700 52,700 (6,600) Required purchases $ 43,900 Based on this information the amount of accounts payable appearing on the March 31 pro forma balance sheet is Multiple Choice $19,830. $46,270. $66,100. None of the answers is correct.
Ahmed Company purchases all merchandise on credit. It recently budgeted the month-end accounts payable balances below. Cash payments on accounts payable during each month are expected to be June, $1,450,000; July, $1,300,000; and August, $1,300,000. Hint: Use the relation (Beg. Accounts Payable + Purchases on Credit - Payments on Accounts Payable = End. Accounts Payable) to solve for budgeted purchases. Accounts payable May 31 June 30 $ 130,000 $ 110,000 Ending accounts payable Add: Cash paid on accounts payable Total accounts payable Less: Beginning accounts payable Budgeted merchandise purchases Computing budgeted merchandise purchases from accounts payable Budgeted amounts: $ June July 31 $ 400,000 0 0 $ July 0 August 31 $ 170,000 0 $ August 0 0
Griffith Company has budgeted purchases of inventory for December of $105,000. Expected beginning inventory on December 1 and ending inventory on December 31 are $120,000 and $129,000, respectively. If the cost of goods sold averages 75% of sales, what are budgeted sales for December? A. $114,000 B. $152,000 C. $120,000 D. $128,000
Rooney Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Rooney’s policy is to maintain an ending inventory balance equal to 15 percent of the following month’s cost of goods sold. April’s budgeted cost of goods sold is $82,000. Required Complete the inventory purchases budget by filling in the missing amounts. Determine the amount of cost of goods sold the company will report on its first quarter pro forma income statement. Determine the amount of ending inventory the company will report on its pro forma balance sheet at the end of the first quarter.
Old Antique Store prepared the following budget information for the month of May: Sales are budgeted at $303,000. All sales are on account and a provision for bad debts is made for each month at three percent of sales for the month. Inventory was $91,000 on April 30; an inventory increase of $17,000 is planned for May 31. All inventory is marked to sell at cost plus 50 percent. Estimated cash disbursements for selling and administrative expenses for the month are $55,000. Depreciation for May is projected at $6,700. Old Antique's budgeted cost of inventory purchases for May is:Multiple Choice $101,000. $151,500. $203,200. $219,000. $202,000.
3
Please help me with show all calculation thanku

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS