Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cash budget is inccorect I posted it here before and I got a wrong answer anyone can help?! Hillyard Company, an office supplies specialty store,

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Cash budget is inccorect I posted it here before and I got a wrong answer anyone can help?!

Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company's general ledger showed the following account balances: a. Cash Accounts receivable Inventory Buildings and equipment (net) Accounts payable Common stock Retained earnings $ 56,000 212,800 60,150 366,000 $ 89,925 500,000 105,025 $ 694,950 $694,950 b. Actual sales for December and budgeted sales for the next four months are as follows: December(actual) January Februay March April $266,000 $401,000 $598,000 $313,000 $209,000 C. Sales are 20% for cash and 80% on credit. All payments on credit sales are collected in the month following sale. The accounts receivable at December 31 are a result of December credit sales. d. The company's gross margin is 40% of sales. (In other words, cost of goods sold is 60% of sales.) e. Monthly expenses are budgeted as follows: salaries and wages, $31,000 per month: advertising, $65,000 per month. Shipping, 5% of sales; other expenses. 3% of sales. Depreciation, including depreciation on new assets acquired during the quarter, will be $44,660 for the quarter. Each month's ending inventory should equal 25% ofthe following month's cost of goods sold f. g. One-half of a month's inventory purchases is paid for in the month of purchase; the other half is paid h. During February, the company will purchase a new copy machine for $2,600 cash. During March, i. During January, the company will declare and pay $45,000 in cash dividends. in the following month other equipment will be purchased for cash at a cost of $78,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Information Audit A Practical Guide

Authors: Susan Henczel, Sue Henczel

1st Edition

3598243677, 978-3598243677

More Books

Students also viewed these Accounting questions

Question

Integrate oral citations of your sources into your speech.

Answered: 1 week ago

Question

Develop a program for effectively managing diversity. page 303

Answered: 1 week ago

Question

List the common methods used in selecting human resources. page 239

Answered: 1 week ago