Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Accounting team at Sheffield Corp. plans to jump start on its budget for the second quarter, since the first quarter is going well; team

The Accounting team at Sheffield Corp. plans to jump start on its budget for the second quarter, since the first quarter is going well; team members want to determine the cash effects of the company's sales as well as its biggest production related cash expenditure, direct materials. The team has gathered the following data:
1.- The budgeted selling price for the year is $3.60 p/unit. Sales volumes are budgeted as follows for the last month of quarter 1, for all of quarter 2, and for part of quarter 3.
March April May June July August
24,70022,70025,80026,30024,00026,100
2. Historically 25% of Sheffield's sales are cash sales, of the remaining credit sales, 40% are collected in the month of sale, while 56% are collected the following month, any remainder is deemed uncollectable.
3. Management sets its ending FG inventory goal at 10% 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 Sheffield's primary direct material is 20% of the following months' production needs, since it's nit unusual for suppliers to stock out of this key resource. Each completed unit requires 4 pounds of DM at an expected cost of $0.30 per pound.
5. Sheffield pays for 35% of its purchases in the month of purchase and 65% the month after purchase. Total budgeted purchases in March are $16,600.
(a)- Prepare sales forecast and corresponding cash receipts budget for Sheffield Corp for its second quarter.
(b)- Prepare Sheffield Corp production budget and DM purchases budget for the second quarter.
(c)- Prepare Sheffield Corp cash disbursement budget for the DM purchases for the second quarter.
(e)- Calculate how much total COGS p/u could be for the company to generate 40% gross margin on its sales.
Considering DM cost p/u , how much of this total COGS p/u is available to cover DL and MOH costs?

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_2

Step: 3

blur-text-image_3

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

Financial Statement Analysis

Authors: K. R. Subramanyam, John Wild

11th edition

78110963, 978-0078110962

More Books

Students also viewed these Accounting questions