Data Year 2 Quarter Year 3 Quarter 2 3 4 1 Budgeted unit sales 40,000 60,000...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Data Year 2 Quarter Year 3 Quarter 2 3 4 1 Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 • Selling price per unit • Accounts receivable, beginning balance • Sales collected in the quarter sales are made • Sales collected in the quarter after sales are made • Desired ending finished goods inventory is • Finished goods inventory, beginning • Raw materials required to produce one unit • Desired ending inventory of raw materials is • Raw materials inventory, beginning • Raw material costs Raw materials purchases are paid $8 $65.000 75% 25% 30% of the budgeted unit sales of the next quarter 12,000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds $0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase $81,500 and • Accounts payable for raw materials, beginning balance Enter a formula into each of the cells marked with a ? below Review Problem: Budget Schedules Construct the sales budget Year 2 Quarter Year 3 Quarter 2 4 1 Budgeted unit sales ? ? ? Selling price per unit Total sales Construct the schedule of expected cash collections Year 2 Quarter 2 3 4 Year Beginning balance accounts receivable First-quarter sales Second-quarter sales Third-quarter sales Fourth-quarter sales Total cash collections Construct the production budget Year 2 Quarter Year 3 Quarter 3 4 Year 2 Budgeted unit sales Add desired ending finished goods inventory Total needs Less beginning finished goods inventory Required production in units ? Construct the raw materials purchases budget Year 2 Quarter Year 3 Quarter 4 Year Required production (units) Raw materials required to produce one unit (pounds) Production needs (pounds) Add desired ending inventory of raw materials (pounds) Total needs (pounds) Less beginning inventory of raw materials (pounds) Raw materials to be purchased (pounds) Cost of raw materials per pound Cost of raw materials to be purchased Construct the schedule of expected cash payments Year 2 Quarter 4 Year Beginning balance accounts payable First-quarter purchases Second-quarter purchases Third-quarter purchases Fourth-quarter purchases Total cash disbursements Data Year 2 Quarter Year 3 Quarter 2 3 4 1 Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 • Selling price per unit • Accounts receivable, beginning balance • Sales collected in the quarter sales are made • Sales collected in the quarter after sales are made • Desired ending finished goods inventory is • Finished goods inventory, beginning • Raw materials required to produce one unit • Desired ending inventory of raw materials is • Raw materials inventory, beginning • Raw material costs Raw materials purchases are paid $8 $65.000 75% 25% 30% of the budgeted unit sales of the next quarter 12,000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds $0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase $81,500 and • Accounts payable for raw materials, beginning balance Enter a formula into each of the cells marked with a ? below Review Problem: Budget Schedules Construct the sales budget Year 2 Quarter Year 3 Quarter 2 4 1 Budgeted unit sales ? ? ? Selling price per unit Total sales Construct the schedule of expected cash collections Year 2 Quarter 2 3 4 Year Beginning balance accounts receivable First-quarter sales Second-quarter sales Third-quarter sales Fourth-quarter sales Total cash collections Construct the production budget Year 2 Quarter Year 3 Quarter 3 4 Year 2 Budgeted unit sales Add desired ending finished goods inventory Total needs Less beginning finished goods inventory Required production in units ? Construct the raw materials purchases budget Year 2 Quarter Year 3 Quarter 4 Year Required production (units) Raw materials required to produce one unit (pounds) Production needs (pounds) Add desired ending inventory of raw materials (pounds) Total needs (pounds) Less beginning inventory of raw materials (pounds) Raw materials to be purchased (pounds) Cost of raw materials per pound Cost of raw materials to be purchased Construct the schedule of expected cash payments Year 2 Quarter 4 Year Beginning balance accounts payable First-quarter purchases Second-quarter purchases Third-quarter purchases Fourth-quarter purchases Total cash disbursements
Expert Answer:
Answer rating: 100% (QA)
Sales Budget Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted Unit Sales 40000 60000 100000 50000 ... View the full answer
Related Book For
Cornerstones of Cost Management
ISBN: 978-1285751788
3rd edition
Authors: Don R. Hansen, Maryanne M. Mowen
Posted Date:
Students also viewed these accounting questions
-
General Motors finished goods inventory is composed primarily of automobiles. Are automobiles always classified as inventory on the balance sheets of all companies? Explain.
-
Marcy Jones, Bates & Hill Fabricators' purchasing manager, has just received the company's production budget for the first quarter. January February March Quarter Budgeted Production 22,200...
-
Compare the number of ATP molecules required to produce one glucose molecule in photosynthesis (see figure 5.9) with the number of ATP molecules generated per glucose in aerobic respiration (see...
-
Jillian operates a sporting goods store in a rented location at a shopping mall. She is insured under a CGL policy with the following limits: Indicate the dollar amount, if any, that Jillians insurer...
-
The block diagram of a position control system is shown in Figure P12.7. For a particular system with proportional control, G1 (s) = Kp, the open-loop transfer function is G (s) = 2.5Kp / s (s + 2)...
-
Question 7: Determine the mean and the variance for the (continuous) random variables with the following moment-generating function: = M(t) (1-4t)-2 (12 marks)
-
On April 1, Topeka Brake Mfg. purchased new production scheduling software for \(\$ 480,000\). On May 15 , a representative of a computerized manufacturing technology company demonstrated new...
-
Kleener Co. acquired a new delivery truck at the beginning of its current fiscal year. The truck cost $26,000 and has an estimated useful life of four years and an estimated salvage value of $4,000....
-
You are considering investing either of the three stocks- A, B and C. The following table provides the information regarding the stocks Returns (in percent) Probability Stock A Stock B Stock C 0.20 2...
-
Pathfinder College is a small liberal arts college that wants to improve its admissions process. In particular, too many of its incoming freshmen have failed to graduate for a variety of reasons,...
-
1. Company A wants to earn $5,000 profit in the month of January. If their fixed costs are $10,000 and their product has a per-unit contribution margin of $250, how many units must they sell to reach...
-
A CAT scan of a human pancreas shows cross-sections spaced 1 cm apart. The pancreas is 12 cm long and the cross-sectional areas, in square centimeters, are 7.5, 15.0, 18.0, 10.3, 11.0, 9.7, 8.9, 7.7,...
-
What is wrong with the following program? (10) #include namespace std; int main() { } cout
-
48) Jamal, Kareem, Rashid and Associates are in the process of evaluating its new client services for the business consulting division. . . Estate Planning, a new service, incurred $190,000 in...
-
An analytical chemist obtains a sample of a novel organic acid and is asked to confirm its molecular weight. The mass spectrometer in the lab is out of order, so they opt to perform a back titration....
-
A , B , and C plan to liquidate their Ocean Breeze Pool and Spa business. They have always shared profit and losses in a ratio of 1 : 4 : 5 ratio, and on the day of liquidation their balance sheet...
-
Describe what an ETF is and how an ETF operates.
-
What types of questions can be answered by analyzing financial statements?
-
Identify some possible causal factors for the following support departments: a. Cafeteria b. Custodial services c. Laundry d. Receiving, shipping, and stores e. Maintenance f. Personnel g. Accounting...
-
For the following activities and their associated resources, identify the following: (1) A cost driver, (2) Flexible resources, and (3) Committed resources. Also, label each resource as one of the...
-
Harvey Company produces two models of blenders: the Super Model (priced at $400) and the Special Model (priced at $200). Recently, Harvey has been losing market share with its Special Model because...
-
Use of a payroll service bureau or a PEO provides all of these benefits except which of the following? a. integration of payroll and personnel data, such as job skills b. lower cost of processing...
-
Which document lists the components needed to manufacture a specific product? a. operations list b. master production schedule c. bill of materials d. production order
-
This chapter noted many of the benefits that can arise by integrating the HRM and payroll databases. Nevertheless, many companies maintain separate payroll and HRM information systems. Why do you...
Study smarter with the SolutionInn App