Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ACC 311 Project Two Scenario You are the cost accountant at Poseys Pet Emporium tasked with preparing quarterly budgets that determine the cash effects of

ACC 311 Project Two Scenario You are the cost accountant at Poseys Pet Emporium tasked with preparing quarterly budgets that determine the cash effects of the companys 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. June July August September October 33,500 32,000 35,200 35,000 34,000 2. Historically, 20% of Poseys 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 months sales volume. The accounting team expects this policy will be met at the beginning of the second quarter. 4. The target ending inventory for Poseys primary direct material is 20% of the following months production needs. Each completed unit requires five pounds of direct materials at an expected cost of $0.25 per pound. 5. Poseys pays for 40% of its purchases in the month of purchase and 60% the month after purchase. Total budgeted purchases in March are $20,000. 6. Poseys ending cash balance on June 30 was $57,950. 7. Poseys non-production cash disbursements are estimated at $80,000 per month.

Posey's Pet Emporium Sales Forecast July August September Quarter Budgeted sales volume [Insert formula] [Insert formula] [Insert formula] [Insert formula] Budgeted selling price [Insert formula] [Insert formula] [insert formula] [Inseert formula] Budgeted sales revenue [Insert formula] [insert formula] [Insert formula] [Insert formula] Cash Receipts Budget July August September Quarter Beginning A/R (June collections) [Insert formula] [Insert formula] July cash sales [Insert formula] [Insert formula] July credit sales [Insert formula] [Insert formula] [Insert formula] August cash sales [Insert formula] [Insert formula] August credit sales [Insert formula] [Insert formula] [Insert formula] September cash sales [Insert formula] [Insert formula] September credit sales [Insert formula] [Insert formula] Total cash receipts [Insert formula] [Insert formula] [Insert formula] [Insert formula]

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

HR Self Audits A Strategy For Continuous Improvement

Authors: Wynette Harewood, Marilyn Silverman

1st Edition

B0BQXT8R3P, 979-8843293192

More Books

Students also viewed these Accounting questions

Question

Prepare and properly label figures and tables for written reports.

Answered: 1 week ago