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...
-
(b) How many rows are needed to construct the membership table for a set made up from the sets A1, A2, ... , An, using ©, U, and ¯? (c) Given the membership tables for two sets A, B, how...
-
A partial amortization schedule for a 10-year note payable issued on January 1, Year 1, is shown next: Required a. Using a financial statements model like the one shown next, record the appropriate...
-
Assuming the same data as given in problem 9, was the well in each case profitable? Discuss your answer. Problem 9:- Property cost (acquisition cost). Drilling cost (one well). Estimated completion...
-
Trattner Company had a beginning inventory on January 1 of 100 units of Product SXL at a cost of $20 per unit. During the year, purchases were: Mar. 15 300 units at $23 Sept. 4 ... 290 units at $28...
-
1. Which of the following formulas can be considered an algorithm for computing the area of a triangle whose side lengths are given positive numbers a, b, and c? Explain these. a. Sp(p-a)(p - b)(pc),...
-
This Mini Practice Set will help you review all the key concepts of the account- ing cycle for a merchandising company along with the integration of payroll. Betty Loeb took over the business now...
-
Image transcription text April 13, 2023 April 13, 2023 April 13, 2023 ECD: 415 Foundations of Play and Learning ECD: 415 Foundations of Play and Learning ECD: 415 Foundations of Play and Learning...
-
2. You and your friend are on opposite sides of a river with a width of 250.0 m flowing directly to the west at 0.800 m/s. Your friend is not directly across from you, but is 150 m downstream on the...
-
Divide and simplify, if possible. 5x+25 (x+5)2 4x-8 (x-2)
-
You are working in community hospital in a small town in West Virginia, The population of the town is 23,000. There were 6 new cases of Rocky Mountain spotted fever diagnosed in the past year....
-
Reasons why audiometric testing results may not be representative of noise exposure at workplace?
-
A 10 m beam of negligible weight is balancing in equilibrium with a fulcrum placed 5 m from it's left end. If a force of 43 N is applied on it's right end, how much force would needs to be applied to...
-
Research says color can affect your mood, behavior, and even stress levels. How do marketing researchers use items like color when marketing? Identify some of the most prominent brand logos. Are the...
-
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...
-
A first-order dynamic system is modeled as \[\dot{y}+3 y=f(t), y(0)=1\] Assuming the input \(f(t)\) is a step function with magnitude 0.8 , find \(y_{s s}\).
-
The nonlinear state-variable equations for a dynamic system are derived as Plot \(x_{1}(t)\) versus \(0 \leq t \leq 10\) by a. Using the RK4 method. b. Simulating the Simulink model of the system. [...
-
Draw the Bode plot and identify the corner frequency, as well as the asymptotic approximations of magnitude for low-frequency and high-frequency ranges. \(G(s)=\frac{4}{3 s+\frac{2}{3}}\)
Distributed Medium Access Control In Wireless Networks 1st Edition - ISBN: 9781461466017 - Free Book
Study smarter with the SolutionInn App