{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-05-28T03:11:09-04:00", "answer_date": "2024-05-28 03:11:09", "is_docs_available": "", "is_excel_available": "", "is_pdf_available": "", "count_file_available": 0, "main_page": "student_question_view", "question_id": "1815722", "url": "\/study-help\/questions\/aztec-company-sells-its-product-for-170-per-unit-its-1815722", "question_creation_date_js": "2024-05-28T03:11:09-04:00", "question_creation_date": "May 28, 2024 03:11 AM", "meta_title": "[Solved] Aztec Company sells its product for $170 | SolutionInn", "meta_description": "Answer of - Aztec Company sells its product for $170 per unit. Its actual and budgeted sales follow. Sales units Sales dollars May | SolutionInn", "meta_keywords": "aztec,company,sells,product,$170,per,unit,actual,budgeted,sales,follow,units", "question_title_h1": " Aztec Company sells its product for $170 per unit. Its actual and budgeted sales follow. Sales units Sales dollars May (Actual) June (Budget) July", "question_title": " Aztec Company sells its product for $170 per unit. Its actual", "question_title_for_js_snippet": "Aztec Company sells its product for $170 per unit Its actual and budgeted sales follow Sales units Sales dollars May (Actual) June (Budget) July (Budget) August (Budget) 2,400 $ 408,000 4,500 $ 765,000 3,500 $595,000 3,700 $ 629,000 All sales are on credit Collections are as follows 26 is collected in the month of the sale, and the remaining 74 is collected in the month following the sale Merchandise purchases cost $110 per unit For those purchases, 60 is paid in the month of purchase and the other 40 is paid in the month following purchase The company has a policy to maintain an ending monthly inventory of 19 of the next month's unit sales The May 31 actual inventory level of 855 units is consistent with this policy Selling and administrative expenses of $133,000 per month are paid in cash The company's minimum cash balance at month end is $130,000 Loans are obtained at the end of any month when the preliminary cash balance is below $130,000 Any preliminary cash balance above $130,000 is used to repay loans at month end This loan has a 0 5 monthly interest rate On May 31, the loan balance is $42,000, and the company's cash balance is $130,000 Required 1 Prepare a schedule of cash receipts from sales for each of the months of June and July 2 Prepare the merchandise purchases budget for June and July 3 Prepare a schedule of cash payments for merchandise purchases for June and July Assume May's budgeted merchandise purchases is $307,890 4 Prepare a cash budget for June and July, including any loan activity and interest expense Compute the loan balance at the end of each month ", "question_description": "\"image\"image\"image\"image\"image", "transcribed_text": "Aztec Company sells its product for $170 per unit. Its actual and budgeted sales follow. Sales units Sales dollars May (Actual) June (Budget) July (Budget) August (Budget) 2,400 $ 408,000 4,500 $ 765,000 3,500 $595,000 3,700 $ 629,000 All sales are on credit. Collections are as follows: 26% is collected in the month of the sale, and the remaining 74% is collected in the month following the sale. Merchandise purchases cost $110 per unit. For those purchases, 60% is paid in the month of purchase and the other 40% is paid in the month following purchase. The company has a policy to maintain an ending monthly inventory of 19% of the next month's unit sales. The May 31 actual inventory level of 855 units is consistent with this policy. Selling and administrative expenses of $133,000 per month are paid in cash. The company's minimum cash balance at month-end is $130,000. Loans are obtained at the end of any month when the preliminary cash balance is below $130,000. Any preliminary cash balance above $130,000 is used to repay loans at month-end. This loan has a 0.5% monthly interest rate. On May 31, the loan balance is $42,000, and the company's cash balance is $130,000. Required: 1. Prepare a schedule of cash receipts from sales for each of the months of June and July. 2. Prepare the merchandise purchases budget for June and July. 3. Prepare a schedule of cash payments for merchandise purchases for June and July. Assume May's budgeted merchandise purchases is $307,890. 4. Prepare a cash budget for June and July, including any loan activity and interest expense. Compute the loan balance at the end of each month.", "related_book": { "title": "Human Resource Management", "isbn": "053845315X, 978-0538453158", "edition": "13th Edition", "authors": "Robert L. Mathis, John H. Jackson", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/80.jpg", "uri": "\/textbooks\/human-resource-management-13th-edition-80", "see_more_uri": "" }, "free_related_book": { "isbn": "979-8860727540", "uri": "\/textbooks\/stop-hunting-and-market-traps-the-untold-secret-mosttraders-don-t-know-1st-edition-979-8860727540-187754", "name": "Stop Hunting And Market Traps The Untold Secret Mosttraders Don T Know", "edition": "1st Edition" }, "question_posted": "2024-05-28 03:11:09", "see_more_questions_link": "\/study-help\/questions\/business-corporate-finance-2020-July-01", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/study-help\/questions\/if-you-were-a-hedge-fund-manager-which-style-would-471333", "description": "If you were a hedge fund manager, which style would you employ and why? Describe this style and how it works. Why would you utilize it and under what macroeconomic conditions would this style work...", "stars": 3 }, { "url": "\/draw-the-network-representation-of-the-following-network", "description": "Draw the network representation of the following network flow problem. What kind of network flow problem is this? MIN: +2X13 + 6X14 + 5X15 + 4X23 + 3X24 + 7X25 Subject to: - X13 - X14 - X15 = - 8 +...", "stars": 3 }, { "url": "\/study-help\/theory-of-probability\/8-consider-ndigit-numbers-where-each-digit-is-one-of-1972770", "description": "8. Consider n-digit numbers where each digit is one of the 10 integers 0, 1,..., 9. How many such numbers are there for which (a) no two consecutive digits are equal; (b) 0 appears as a digit a total...", "stars": 3 }, { "url": "\/study-help\/coaching-supervision-a-practical-guide-for-supervisees\/2-what-do-you-perceive-as-the-main-challenge-in-1983710", "description": "2 What do you perceive as the main challenge in designing group coach-ing programs?", "stars": 3 }, { "url": "\/process-costing-systemdetermine-equivalent-units-and-allocate-costs-milwaukee-ski", "description": "Process costing systemdetermine equivalent units and allocate costs Milwaukee Ski Company manufactures snow skis. During the most recent accounting period, the companys finishing department...", "stars": 3 }, { "url": "\/study-help\/questions\/required-information-cc-9-1-static-accounting-9747960", "description": "Required information CC 9 - 1 ( Static ) Accounting for the Use and Disposal of Long - Lived Assets [ LO 9 - 3 , LO 9 - 5 ] Skip to question [ The following information applies to the questions...", "stars": 3 }, { "url": "\/study-help\/questions\/2-short-term-one-year-interest-years-over-the-next-6039367", "description": "2) Short term (one year) interest years over the next 6 years will be 0.6, 1.1, 1.8, 2, 1.6, and 5.1. Assume that the investors prefer holding short-term bonds so that liquidity premium of 10 basis...", "stars": 3 }, { "url": "\/study-help\/questions\/for-a-set-of-70-coin-flips-we-record-21-1370801", "description": "For a set of 70 coin flips, we record 21 heads and 49 tails. 1) If p is the true probability of heads, what is our best estimate for p here? 2) What is our best estimate for the standard deviation", "stars": 3 }, { "url": "\/study-help\/questions\/question-1-corinth-biotech-limited-cbl-started-operations-in-january-5624671", "description": "Question 1 Corinth Biotech Limited (CBL) started operations in January 2018. CBL reports under IFRS. The following activities occurred during the year: 1. On January 31, 2018, the shareholder, John...", "stars": 3 }, { "url": "\/study-help\/questions\/andreti-company-has-a-single-product-called-a-dak-the-7075506", "description": "Andreti Company has a single product called a Dak. The company normally produces and sells 86,000 Daks each year at a selling price of $56 per unit The company's unit costs at this level of activity...", "stars": 3 }, { "url": "\/study-help\/questions\/please-slove-fast-and-use-australian-taxation-law-for-reference-4634791", "description": "Please slove fast and use Australian taxation law for reference Steve is an editor employed full time at a major Australian book publisher \"WritePublishing\". In his spare time, Steve enjoys writing...", "stars": 3 }, { "url": "\/study-help\/questions\/what-is-the-seribram-8050404", "description": "What is the cerebrum?", "stars": 3 }, { "url": "\/study-help\/questions\/you-deposit-13000-a-year-into-an-account-that-pays-8337021", "description": "You deposit 13,000 a year into an account that pays 8%. What will it be worth in 25 years? Using Excel", "stars": 3 }, { "url": "\/nitrogen-monoxide-reacts-with-hydrogen-as-follows-2nog-h2g-n2og", "description": "Nitrogen monoxide reacts with hydrogen as follows: 2NO(g)+ H2(g) N2O(g) + H2O(g) The rate law is [H2]\/ t = k[NO]2[H2], where k is 1.10 107 L2\/(mol2s) at 826oC. A vessel contains NO and H2 at...", "stars": 3 }, { "url": "\/study-help\/fundamentals-of-financial-management-\/a-company-has-current-liabilities-of-500million-and-its-current-1665601", "description": "A company has current liabilities of $500million, and its current ratio is 2 0. What is the total of its current assets? ($1,000 million) If this firms quick ratio is 1 6, how much inventory does it...", "stars": 3 }, { "url": "\/study-help\/fundamentals-of-financial-management-\/write-the-equations-for-four-ratios-that-are-used-to-1665600", "description": "Write the equations for four ratios that are used to measure how effectively a firm manages its assets. AppendixLO1", "stars": 3 }, { "url": "\/study-help\/fundamentals-of-financial-management-\/what-question-are-the-two-liquidity-ratios-designed-to-answer-1665603", "description": "What question are the two liquidity ratios designed to answer? AppendixLO1", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/case-53-algo-shouldice-hospital-in-canada-is-widely-known-1815721", "next": "\/study-help\/questions\/ramada-company-produces-one-golf-cart-model-a-partially-complete-1815723" }, "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": " Aztec Company sells its product for $170 per unit. Its actual", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/aztec-company-sells-its-product-for-170-per-unit-its-1815722" } ], "skill_details": { "skill_id": "9", "skill_name": "Accounting", "parent_id": "1" } }" } }