a. What are the total expected cash collections for the year under this revised budget? Expected...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
a. What are the total expected cash collections for the year under this revised budget? Expected cash collections for the year b. What is the total required production for the year under this revised budget? Total required production for the year c. What is the total cost of raw materials to be purchased for the year under this revised budget? Total cost of raw materials to be purchased for the year d. What are the total expected cash disbursements for raw materials for the year under this revised budget? Total expected cash disbursements for raw materials for the year e. After seeing this revised budget, the production manager cautioned that due to the current production constraint, a complex milling machine, the plant can produce no more than 90,000 units in any one quarter. Is this a potential problem? O No O Yes A D E. G. Chapter 8: Applying Excel Data Year 3 Quarter 4 2 Budgeted unit sales 45,000 65,000 120,000 75,000 2.000 95,000 - Seling price per unit 7 per unit 65,000 Accounts receivable, beginning balance %24 • Sales collected in the quarter sales are made 75% Sales collected in the quarter after sales are made 25% 2. - Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter Finished goods inventory, beginning - Raw materials required to produce one unit - Desired ending inventory of raw materials is • Raw materials inventory, beginning 12,000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds - Raw material costs 0.80 per pound • Raw materials purchases are paid 60% in the quarter the purchases are made and 40% in the quarter following purchase Accounts payable for raw materials, beginning balance 81,500 a. What are the total expected cash collections for the year under this revised budget? Expected cash collections for the year b. What is the total required production for the year under this revised budget? Total required production for the year c. What is the total cost of raw materials to be purchased for the year under this revised budget? Total cost of raw materials to be purchased for the year d. What are the total expected cash disbursements for raw materials for the year under this revised budget? Total expected cash disbursements for raw materials for the year e. After seeing this revised budget, the production manager cautioned that due to the current production constraint, a complex milling machine, the plant can produce no more than 90,000 units in any one quarter. Is this a potential problem? O No O Yes A D E. G. Chapter 8: Applying Excel Data Year 3 Quarter 4 2 Budgeted unit sales 45,000 65,000 120,000 75,000 2.000 95,000 - Seling price per unit 7 per unit 65,000 Accounts receivable, beginning balance %24 • Sales collected in the quarter sales are made 75% Sales collected in the quarter after sales are made 25% 2. - Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter Finished goods inventory, beginning - Raw materials required to produce one unit - Desired ending inventory of raw materials is • Raw materials inventory, beginning 12,000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds - Raw material costs 0.80 per pound • Raw materials purchases are paid 60% in the quarter the purchases are made and 40% in the quarter following purchase Accounts payable for raw materials, beginning balance 81,500
Expert Answer:
Answer rating: 100% (QA)
Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 Budgeted unit sales 50000 65000 120000 65000 80000 9500... View the full answer
Related Book For
Corporate Finance A Focused Approach
ISBN: 978-1439078082
4th Edition
Authors: Michael C. Ehrhardt , Eugene F. Brigham
Posted Date:
Students also viewed these accounting questions
-
What are the total expected cash collections for the year under this revised budget? What is the total required production for the year under this revised budget? Data Budgeted unit sales Selling...
-
What are the total impedance, phase angle, and rms current in and LRC circuit connected to a 10.0-kHz, 725-V (rms) source if L = 22.0 mH, R = 8.70 k, and C = 3250 pF?
-
What are the total return, the current yield, and the capital gains yield for the discount bond? (Assume the bond is held to maturity and the company does not default on the bond.)
-
Blocks A and B shown in the figure are free and all surfaces are non-friction. Find the velocity of the blocks at t = 3 s, since the tensile force shown in the graphic is applied to the block A...
-
A-1 Appliance provides repair services for all makes and models of home appliances. A-1 Appliance charges customers for labour on each job at a rate of $50 per hour. The labour rate is high enough to...
-
For each of the following lists of premises, derive the indicated conclusion and complete the justification. For tautology, derive a conclusion that is simpler than the premise. 1. 2. 3. 4. 5. 6. 7....
-
Consider Example 3.5. For each of the 10 boys, we randomly assigned the left or right sole to material A and the remaining side to B. Use $R$ 's sample function to simulate a treatment assignment....
-
a. From Williss point of view, is litigation or ADR preferred? Why? b. From Telwedas point of view, is litigation or ADR preferred? Why? c. Which form of ADR could be preferred by the two companies?...
-
What is the error to this Matlab code for part 3b? Please do parts 3b - 3e Image transcription text WC=1; [-,idx] = min (abs (wout - wc) ) ; A = mag (idx) ; - theta = phaseDeg (idx) ; DO YOUIA WN t...
-
In cell C11, construct a formula to calculate the annual projected street maintenance costs for the year 2025 after the projected increase of 5% is applied. Use absolute cell references as necessary....
-
The average cost for a company to produce x units of a product is given by the function A(x) = to estimate the change in average cost as production goes from 250 units to 251 units. The change in...
-
How do securities in foreign marketsstocks and bondsfigure into investment choice? What must be taken into account when considering such foreign assets for a portfolio?
-
What is meant by a payment instruction? How are they submitted to banks?
-
Why might investors be cautious about buying participations in a securitized pool of loans? How is this related to adverse selection? How might they be assured about the underlying quality of assets...
-
How would a balanced budget amendment to the U.S. Constitution affect the demand for funds by deficit spending units? What would happen to the level of interest rates in the United States?
-
What is a forward market?
-
Consider the following Turing Machine. Its input alphabet is {0,1}. Transitions to the REJECT state are not shown ("if stuck, then reject"). A 1- R 3 UR accept 0 L,R UR U-blank 5 0,1,R UL 0L,L 0,1,L...
-
Is that Yelp review real or fake? The article A Framework for Fake Review Detection in Online Consumer Electronics Retailers (Information Processing and Management 2019: 12341244) tested five...
-
What is the rationale behind the NPV method? According to NPV, which franchise or franchises should be accepted if they are independent? Mutually exclusive?
-
Now calculate the corporate value. Assume you have just been hired as a business manager of PizzaPalace, a regional pizza restaurant chain. The companys EBIT was $50 million last year and is not...
-
After a 5-for-1 stock split, the Strasburg Company paid a dividend of $0.75 per new share, which represents a 9% increase over last years pre-split dividend. What was last years dividend per share?
-
If the angle between vectors \(\vec{A}\) and \(\vec{B}\) is \(110^{\circ}\) and if \(A=1.7 \mathrm{~N}\) and \(B=2.0 \mathrm{~m}\), what is the value of \(\vec{A} \cdot \vec{B}\) ?
-
You throw a textbook to a friend who is at their dormitory window \(2.2 \mathrm{~m}\) above you. You are standing \(4.0 \mathrm{~m}\) away from the building and your throw is perfectly made such that...
-
A force \(\vec{F}=F_{x} \hat{\imath}+F_{y} \hat{\jmath}\) with \(F_{x}=50 \mathrm{~N}\) and \(F_{y}=12 \mathrm{~N}\) is exerted on a particle as the particle moves along the \(x\) axis from \(x=1.0...
Study smarter with the SolutionInn App