Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I've filled out most of the work but I'm struggling to complete a cash budget sheet. Request if I can get some assistance on what
I've filled out most of the work but I'm struggling to complete a cash budget sheet. Request if I can get some assistance on what formulas should be used when filling out a cash budget spreadsheet and a clear explanation.
Acc 311 6-1 Problem set \\#3.odt - Trio Office Writer File Edit View Insert Format Styles Table Form Iools Window Help Acc 311 6-1 Problem set \\#3.odt - Trio Office Writer File Edit View Insert Format Styles Table Form Iools Window Help Scenario You are the cost accountant at Posey's Pet Emporium tasked with preparing quarterly budgets that determine the cash effects of the company's sales and production-related expenditures. The company uses a calendar year, and it is time to prepare the third-quarter budget. You have the following information: 1. The budgeted selling price for the year is \\( \\$ 4.99 \\) per unit. Sales volumes are budgeted as follows for the last month of quarter two, for all of quarter three, and for part of quarter four. 2. Historically, \20 of Posey's sales are cash sales. Of the remaining credit sales, \45 are collected in the month of sale, while \52 are collected the following month. The remainder is deemed uncollectible. 3. Management sets its ending finished goods inventory goal at \15 of the following month's sales volume. The accounting team expects this policy will be met at the beginning of the second quarter. 4. The target ending inventory for Posey's primary direct material is \20 of the following month's production needs. Each completed unit requires five pounds of direct materials at an expected cost of \\( \\$ 0.25 \\) per pound. The budgeted production for October is 34,000 . 5. Posey's pays for \40 of its purchases in the month of purchase and \60 the month after purchase. Total budgeted purchases in June are \\( \\$ 20,000 \\). 6. Posey's ending cash balance on June 30 was \\( \\$ 57,950 \\). 7. Posey's non-production cash disbursements are estimated at \\( \\$ 80,000 \\) per month. Acc 311 6-1 Problem set \\#3.odt - Trio Office Writer File Edit View Insert Format Styles Table Form Iools Window Help \\begin{tabular}{|l|r|r|r|r|} \\hline \\( \\begin{array}{l}\\text { September cash } \\\\ \\text { sales }\\end{array} \\) & & & \\( \\$ 34,930.00 \\) & \\( \\$ 34,930.00 \\) \\\\ \\hline \\( \\begin{array}{l}\\text { September credit } \\\\ \\text { sales }\\end{array} \\) & & & \\( \\$ 55,888.00 \\) & \\( \\$ 55,888.00 \\) \\\\ \\hline Total cash receipts & \\( \\$ 140,983.60 \\) & \\( \\$ 162,873.60 \\) & \\( \\$ 169,508.30 \\) & \\( \\$ 473,365.00 \\) \\\\ \\hline \\end{tabular} Page 1 of 4 500 words, 3,399 characters Default Style English (USA) Search (b) Acc 311 6-1 Problem set \\#3.odt - Trio Office Writer File Edit View Insert Format Styles Table Form Iools Window Help Acc 311 6-1 Problem set \\#3.odt - Trio Office Writer File Edit View Insert Format Styles Table Form Iools Window HelpStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started