{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-06-09T16:12:42-04:00", "answer_date": "2024-06-09 16:12:42", "is_docs_available": "", "is_excel_available": "", "is_pdf_available": "", "count_file_available": 0, "main_page": "student_question_view", "question_id": "2524553", "url": "\/study-help\/questions\/hillyard-company-an-office-supplies-specialty-store-gathered-the-following-2524553", "question_creation_date_js": "2024-06-09T16:12:42-04:00", "question_creation_date": "Jun 09, 2024 04:12 PM", "meta_title": "[Solved] Hillyard Company, an office supplies spec | SolutionInn", "meta_description": "Answer of - Hillyard Company, an office supplies specialty store, gathered the following information to prepare its master budget | SolutionInn", "meta_keywords": "hillyard,company,office,supplies,specialty,store,gathered,information,prepare,master,budget,first", "question_title_h1": "Hillyard Company, an office supplies specialty store, gathered the following information to prepare its master budget for the first quarter of the year: As of", "question_title": "Hillyard Company, an office supplies specialty store, gathered the following information to", "question_title_for_js_snippet": "Hillyard Company, an office supplies specialty store, gathered the following information to prepare its master budget for the first quarter of the year As of December 3 1 ( the end of the prior quarter ) , the company s general ledger showed the following account balances Debits Credits Cash $ 4 2 , 0 0 0 Accounts receivable 2 0 1 , 6 0 0 Inventory 5 8 , 0 5 0 Buildings and equipment ( net ) 3 5 2 , 0 0 0 Accounts payable $ 8 5 , 7 2 5 Common stock 5 0 0 , 0 0 0 Retained earnings 6 7 , 9 2 5 $ 6 5 3 , 6 5 0 $ 6 5 3 , 6 5 0 Actual sales for December and budgeted sales for the next four months are as follows December ( actual ) $ 2 5 2 , 0 0 0 January $ 3 8 7 , 0 0 0 February $ 5 8 4 , 0 0 0 March $ 2 9 8 , 0 0 0 April $ 1 9 5 , 0 0 0 Sales are 2 0 for cash and 8 0 on credit All payments on credit sales are collected in the month following sale The accounts receivable at December 3 1 are a result of December credit sales The company s gross margin is 4 0 of sales ( In other words, cost of goods sold is 6 0 of sales ) Monthly expenses are budgeted as follows salaries and wages, $ 1 7 , 0 0 0 per month advertising, $ 5 7 , 0 0 0 per month shipping, 5 of sales other expenses, 3 of sales Depreciation, including depreciation on new assets acquired during the quarter, will be $ 4 2 , 4 2 0 for the quarter Each month s ending inventory should equal 2 5 of the following month s cost of goods sold One half of a month s inventory purchases is paid for in the month of purchase the other half is paid in the following month During February, the company will purchase a new copy machine for $ 1 , 2 0 0 cash During March, other equipment will be purchased for cash at a cost of $ 7 1 , 0 0 0 During January, the company will declare and pay $ 4 5 , 0 0 0 in cash dividends Management wants to maintain a minimum cash balance of $ 3 0 , 0 0 0 The company has an agreement with a local bank allowing it to borrow in increments of $ 1 , 0 0 0 at the beginning of each month The interest rate on these loans is 1 per month, and for simplicity, we will assume interest is not compounded The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter Required Using the data above, complete the following statements and schedules for the first quarter 1 Schedule of expected cash collections 2 a Merchandise purchases budget 2 b Schedule of expected cash disbursements for merchandise purchases 3 Cash budget 4 Prepare an absorption costing income statement for the quarter ending March 3 1 5 Prepare a balance sheet as of March 3 1 ", "question_description": "
Hillyard Company, an office supplies specialty store, gathered the following information to prepare its master budget for the first quarter of the year:<\/span><\/div>
<\/div>
As of December <\/span>3<\/mn>1<\/mn><\/mtext>(<\/mi><\/mrow><\/math>the end of the prior quarter<\/span>)<\/mi>,<\/mo><\/mrow><\/math> the company<\/span><\/mi><\/mrow><\/math>s general ledger showed the following account balances:<\/span> <\/div>
<\/div>
Debits Credits<\/span><\/div>
Cash $ <\/span>4<\/mn>2<\/mn>,<\/mo>0<\/mn>0<\/mn>0<\/mn><\/mrow><\/math> <\/span> <\/div>
Accounts receivable <\/span>2<\/mn>0<\/mn>1<\/mn>,<\/mo>6<\/mn>0<\/mn>0<\/mn><\/mrow><\/math> <\/span> <\/div>
Inventory <\/span>5<\/mn>8<\/mn>,<\/mo>0<\/mn>5<\/mn>0<\/mn><\/mrow><\/math> <\/span> <\/div>
Buildings and equipment <\/span>(<\/mi><\/mrow><\/math>net<\/span>)<\/mi><\/mtext>3<\/mn>5<\/mn>2<\/mn>,<\/mo>0<\/mn>0<\/mn>0<\/mn><\/mrow><\/math> <\/span> <\/div>
Accounts payable $ <\/span>8<\/mn>5<\/mn>,<\/mo>7<\/mn>2<\/mn>5<\/mn><\/mrow><\/math> <\/div>
Common stock <\/span>5<\/mn>0<\/mn>0<\/mn>,<\/mo>0<\/mn>0<\/mn>0<\/mn><\/mrow><\/math> <\/div>
Retained earnings <\/span>6<\/mn>7<\/mn>,<\/mo>9<\/mn>2<\/mn>5<\/mn><\/mrow><\/math> <\/div>
$ <\/span>6<\/mn>5<\/mn>3<\/mn>,<\/mo>6<\/mn>5<\/mn>0<\/mn><\/mrow><\/math> $ <\/span>6<\/mn>5<\/mn>3<\/mn>,<\/mo>6<\/mn>5<\/mn>0<\/mn><\/mrow><\/math> <\/div>
Actual sales for December and budgeted sales for the next four months are as follows:<\/span><\/div>
December<\/span>(<\/mi><\/mrow><\/math>actual<\/span>)<\/mi><\/mrow><\/math> <\/span> <\/div>
$ <\/span>2<\/mn>5<\/mn>2<\/mn>,<\/mo>0<\/mn>0<\/mn>0<\/mn><\/mrow><\/math> <\/div>
January <\/span><\/div>
$ <\/span>3<\/mn>8<\/mn>7<\/mn>,<\/mo>0<\/mn>0<\/mn>0<\/mn><\/mrow><\/math> <\/div>
February <\/span><\/div>
$ <\/span>5<\/mn>8<\/mn>4<\/mn>,<\/mo>0<\/mn>0<\/mn>0<\/mn><\/mrow><\/math> <\/div>
March <\/span><\/div>
$ <\/span>2<\/mn>9<\/mn>8<\/mn>,<\/mo>0<\/mn>0<\/mn>0<\/mn><\/mrow><\/math> <\/div>
April <\/span><\/div>
$ <\/span>1<\/mn>9<\/mn>5<\/mn>,<\/mo>0<\/mn>0<\/mn>0<\/mn><\/mrow><\/math> <\/div>
Sales are <\/span>2<\/mn>0<\/mn>%<\/mo><\/mrow><\/math> for cash and <\/span>8<\/mn>0<\/mn>%<\/mo><\/mrow><\/math> on credit. All payments on credit sales are collected in the month following sale. The accounts receivable at December <\/span>3<\/mn>1<\/mn><\/mrow><\/math> are a result of December credit sales.<\/span> <\/div>
The company<\/span><\/mi><\/mrow><\/math>s gross margin is <\/span>4<\/mn>0<\/mn>%<\/mo><\/mrow><\/math> of sales. <\/span>(<\/mi><\/mrow><\/math>In other words, cost of goods sold is <\/span>6<\/mn>0<\/mn>%<\/mo><\/mrow><\/math> of sales.<\/span>)<\/mi><\/mrow><\/math> <\/div>
Monthly expenses are budgeted as follows: salaries and wages, $<\/span>1<\/mn>7<\/mn>,<\/mo>0<\/mn>0<\/mn>0<\/mn><\/mrow><\/math> per month; advertising, $<\/span>5<\/mn>7<\/mn>,<\/mo>0<\/mn>0<\/mn>0<\/mn><\/mrow><\/math> per month; shipping, <\/span>5<\/mn>%<\/mo><\/mrow><\/math> of sales; other expenses, <\/span>3<\/mn>%<\/mo><\/mrow><\/math> of sales. Depreciation, including depreciation on new assets acquired during the quarter, will be $<\/span>4<\/mn>2<\/mn>,<\/mo>4<\/mn>2<\/mn>0<\/mn><\/mrow><\/math> for the quarter.<\/span> <\/div>
Each month<\/span><\/mi><\/mrow><\/math>s ending inventory should equal <\/span>2<\/mn>5<\/mn>%<\/mo><\/mrow><\/math> of the following month<\/span><\/mi><\/mrow><\/math>s cost of goods sold.<\/span> <\/div>
One<\/span>-<\/mo><\/mrow><\/math>half of a month<\/span><\/mi><\/mrow><\/math>s inventory purchases is paid for in the month of purchase; the other half is paid in the following month.<\/span> <\/div>
During February, the company will purchase a new copy machine for $<\/span>1<\/mn>,<\/mo>2<\/mn>0<\/mn>0<\/mn><\/mrow><\/math> cash. During March, other equipment will be purchased for cash at a cost of $<\/span>7<\/mn>1<\/mn>,<\/mo>0<\/mn>0<\/mn>0<\/mn>.<\/mo><\/mrow><\/math> <\/div>
During January, the company will declare and pay $<\/span>4<\/mn>5<\/mn>,<\/mo>0<\/mn>0<\/mn>0<\/mn><\/mrow><\/math> in cash dividends.<\/span> <\/div>
Management wants to maintain a minimum cash balance of $<\/span>3<\/mn>0<\/mn>,<\/mo>0<\/mn>0<\/mn>0<\/mn>.<\/mo><\/mrow><\/math> The company has an agreement with a local bank allowing it to borrow in increments of $<\/span>1<\/mn>,<\/mo>0<\/mn>0<\/mn>0<\/mn><\/mrow><\/math> at the beginning of each month. The interest rate on these loans is <\/span>1<\/mn>%<\/mo><\/mrow><\/math> per month, and for simplicity, we will assume interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.<\/span> <\/div>
Required:<\/span><\/div>
Using the data above, complete the following statements and schedules for the first quarter:<\/span><\/div>
<\/div>
1<\/mn>.<\/mo><\/mrow><\/math> Schedule of expected cash collections:<\/span> <\/div>
2<\/mn>-<\/mo><\/mrow><\/math>a<\/span>.<\/mo><\/mrow><\/math> Merchandise purchases budget:<\/span> <\/div>
2<\/mn>-<\/mo><\/mrow><\/math>b<\/span>.<\/mo><\/mrow><\/math> Schedule of expected cash disbursements for merchandise purchases:<\/span> <\/div>
3<\/mn>.<\/mo><\/mrow><\/math> Cash budget:<\/span> <\/div>
4<\/mn>.<\/mo><\/mrow><\/math> Prepare an absorption costing income statement for the quarter ending March <\/span>3<\/mn>1<\/mn>.<\/mo><\/mrow><\/math> <\/div>
5<\/mn>.<\/mo><\/mrow><\/math> Prepare a balance sheet as of March <\/span>3<\/mn>1<\/mn>.<\/mo><\/mrow><\/math> <\/div><\/span> <\/div><\/div>", "transcribed_text": "", "related_book": { "title": "The Company Valuation Playbook Invest With Confidence", "isbn": "1838470816, 978-1838470814", "edition": "1st Edition", "authors": "Charles Sunnucks", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/2024\/01\/659e8d7741ff1_719659e8d773d380.jpg", "uri": "\/textbooks\/the-company-valuation-playbook-invest-with-confidence-1st-edition-978-1838470814-187563", "see_more_uri": "" }, "free_related_book": { "isbn": "B0BFV1YKL7", "uri": "\/textbooks\/accounting-ledger-log-book-1st-edition-b0bfv1ykl7-113693", "name": "Accounting Ledger Log Book", "edition": "1st Edition" }, "question_posted": "2024-06-09 16:12:42", "see_more_questions_link": "\/study-help\/questions\/business-economics-2023-September-08", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/for-the-flowpressure-process-shown-in-fig-e-it-is", "description": "For the flow-pressure process shown in Fig. E, it is desired to control both pressure P 1 and flow rate F. The manipulated variables are the stern positions of the control valves, M 1 and M 2 . For...", "stars": 3 }, { "url": "\/suppose-that-x-and-y-have-a-continuous-joint-distribution-for-which-the-joint", "description": "Suppose that X and Y have a continuous joint distribution for which the joint p.d.f. is as follows: Find E(Y|X) and Var(Y |X). fa. vy for0ss1 andoy1, otherwise", "stars": 3 }, { "url": "\/study-help\/psychology-2e\/list-and-describe-major-substantive-contributions-coming-out-of-the-1985021", "description": "List and describe major substantive contributions coming out of the works of Avicenna, Averros, and Alhazen.", "stars": 3 }, { "url": "\/melodee-lane-lingerie-co-was-a-tenant-in-a-building", "description": "Melodee Lane Lingerie Co. was a tenant in a building that was protected against fire by a sprinkler and alarm system maintained by the American District Telegraph Co. (ADT). Because of the latters...", "stars": 3 }, { "url": "\/study-help\/questions\/1-youre-investing-in-a-10unit-apartment-building-the-purchase-9875590", "description": "1. Youre investing in a 10-unit apartment building. The purchase price is $3,000,000. You will finance the purchase with a loan at 75% of the purchase price, due in 10 years, interest rate of 6.25%,...", "stars": 3 }, { "url": "\/study-help\/questions\/abc-credit-finance-is-a-credit-card-provider-with-regional-3435071", "description": "ABC Credit Finance is a credit card provider with regional payment processing centers. You are a manager of one of these centers. You are an at-will employee in a typical at-will jurisdiction. ABC is...", "stars": 3 }, { "url": "\/study-help\/questions\/e519-algo-calculating-contribution-margin-and-contribution-ratio-preparing-contribution-9744260", "description": "E5-19 (Algo) Calculating Contribution Margin and Contribution Ratio, Preparing Contribution Margin Income Statement [LO 5-5] Riverside Inc. makes one model of wooden canoe. Partial information for it...", "stars": 3 }, { "url": "\/study-help\/questions\/do-you-feel-that-your-organization-utilizes-your-uniqueness-to-1005905", "description": "Do you feel that your organization utilizes your uniqueness to its full capability?", "stars": 3 }, { "url": "\/study-help\/questions\/you-have-been-appointed-to-manage-a-project-that-requires-1008125", "description": "You have been appointed to manage a project that requires the construction of a three bedroom house (in an area of your choice). the information that you have received includes: Budget - R2.5 Million...", "stars": 3 }, { "url": "\/study-help\/questions\/answer-the-following-a-what-is-the-role-of-safety-989601", "description": "Answer the following: a. What is the role of safety inventory? What are the risks of not having safety inventory? Explain thoroughly. b. If the quality of goods provided by suppliers is identical,...", "stars": 3 }, { "url": "\/study-help\/questions\/all-problems-must-be-formatted-correctly-in-the-report-to-1024414", "description": "All problems must be formatted correctly in the report to obtain full points. Code must be well commented on and sectioned. Any information missing from the report or the simple act of typing out...", "stars": 3 }, { "url": "\/study-help\/questions\/give-a-specific-example-of-how-corporate-aviation-has-helped-1006110", "description": "Give a specific example of how corporate aviation has helped a company or organization. (See the Learn section for links concerning corporate flight departments). Consider businesses or even how...", "stars": 3 }, { "url": "\/study-help\/questions\/which-is-the-most-frequently-used-method-of-getting-your-5078468", "description": "Which is the most frequently used method of getting your rsum to an employer? Group of answer choices Hand Delivery Fax Mail Company web site E-mail", "stars": 3 }, { "url": "\/study-help\/financial-accounting-an-introduction\/comprehensive-review-problem-exhibit-149-presents-a-consolidated-statement-of-1554985", "description": "Comprehensive review problem. Exhibit 14.9 presents a consolidated statement of income and retained earnings for Year 22, and Exhibit 14.10 presents a consolidated balance sheet for Tuck Corporation...", "stars": 3 }, { "url": "\/study-help\/financial-accounting-an-introduction\/review-the-terms-and-concepts-listed-above-in-key-terms-1554984", "description": "Review the terms and concepts listed above in Key Terms and Concepts. (Appendix)", "stars": 3 }, { "url": "\/study-help\/financial-accounting-an-introduction\/what-is-interest-appendix-1554983", "description": "What is interest? (Appendix)", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/mr-browns-employer-provides-him-with-an-automobile-for-2524552", "next": "\/study-help\/questions\/airqual-test-corporation-provides-on-site-air-quality-testing-2524554" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Business", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business" }, { "name": "Accounting", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-accounting" }, { "name": "Hillyard Company, an office supplies specialty store, gathered the following information to", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/hillyard-company-an-office-supplies-specialty-store-gathered-the-following-2524553" } ], "skill_details": { "skill_id": "9", "skill_name": "Accounting", "parent_id": "1" } } "1" } }