You have been asked to prepare a monthly cash budget for Warwick Ltd. The business is...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have been asked to prepare a monthly cash budget for Warwick Ltd. The business is manufacturing a single product. You have established the following data: 11. i. i. Each product sells at $14 and variable costs per unit are materials of $5 and labour of $3. Monthly fixed costs are $2,000 and are paid at the end of the month to which they relate. The monthly sales and production in units are as follows: Sales on credit (units) Production (units) 1,000 1,200 1,400 1,600 1,700 Month November December January February March 1,200 1,500 1,900 2,000 2,200 Credit customers are expected to pay as follows: 20% in the month of sale, 50% in the month following sale, and 25% 2 months after sale. The remainder will be treated as bad debts. Suppliers of materials are paid in the month of production. Labour's wages are paid in the month of production. A tax payment for $5,000 is expected in March. The company is expected to have an opening balance of $1,000 on 1 January. quired: Prepare a columnar monthly cash budget for each of the three months from January to March. (15 marks) Give five sensible actions that the company can take to address the potential forecasted overdraft in this three-month period. (5 marks) You have been asked to prepare a monthly cash budget for Warwick Ltd. The business is manufacturing a single product. You have established the following data: 11. i. i. Each product sells at $14 and variable costs per unit are materials of $5 and labour of $3. Monthly fixed costs are $2,000 and are paid at the end of the month to which they relate. The monthly sales and production in units are as follows: Sales on credit (units) Production (units) 1,000 1,200 1,400 1,600 1,700 Month November December January February March 1,200 1,500 1,900 2,000 2,200 Credit customers are expected to pay as follows: 20% in the month of sale, 50% in the month following sale, and 25% 2 months after sale. The remainder will be treated as bad debts. Suppliers of materials are paid in the month of production. Labour's wages are paid in the month of production. A tax payment for $5,000 is expected in March. The company is expected to have an opening balance of $1,000 on 1 January. quired: Prepare a columnar monthly cash budget for each of the three months from January to March. (15 marks) Give five sensible actions that the company can take to address the potential forecasted overdraft in this three-month period. (5 marks)
Expert Answer:
Answer rating: 100% (QA)
To prepare the monthly cash budget for Warwick Ltd we need to consider the sales production costs and payment terms provided Heres a columnar monthly ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Maria Alonzo Corporation trial balance as on 3 0 April 2 0 2 2 is as below Debits 1 0 2 , 9 9 4 2 2 7 , 2 1 9 1 , 6 0 0 2 2 5 , 0 0 0 5 7 , 2 0 0 4 , 9 7 3 6 2 4 1 9 , 2 1 1 1 8 , 4 0 0 1 , 4 5...
-
D Hawk entered the market in early 2018. D Hawk manufactures camera drones, selling primarily to retailers. D Hawk is pleased with its financial performance over its first few years of operations,...
-
master budget case camdrone as part of the continued advancement of technology, a drone camera market has emerged in recent years the drone camera market has been growing as more photography...
-
A car manufacturer designs a fuel-efficient car for 1993. The company argues that the car can attain an average of 45 miles per gallon. The miles per gallon of the car follows a normal distribution...
-
How could free Media Player software (either bundled or downloaded with Windows) possibly harm consumers?
-
Suraya Collier, the bookkeeper for Danner, Letourneau, and Majewski, a political consulting firm, has recently completed a managerial accounting course at her local community college. One of the...
-
What are the differences between a release and a covenant not to sue?
-
Refer to the transactions of Circuit Country in P63B. In P63B, at the beginning of June, Circuit Country has a balance in inventory of $3,000. The following transactions occur during the month of...
-
Your company is considering two projects and has estimated the following cash flows: Year Project A Project B 0 - 1 5 , 0 0 0 - 2 0 , 0 0 0 1 ...
-
WRITE IN PYTHON AND IN THE GIVEN CODE coderbyte medium Back-end Challenge In the Python file, write a program to perform a GET request on the route Time left: Unlimited time...
-
common * Given the following codes for each register in the Basic computer to gain the Memory(111), IEN (JK). (Answer 6, 7, 8) bus: AR(001), PC(010), DR(011), AC(100), IR(101), TR(110), NOP I CALL...
-
Recall a social or work-related situation when you felt conversationally challenged. Describe how you could have used the guidelines in this chapter to engage more competently. a. If appropriate,...
-
Mental health experts generally find it is better to have others disagree with you than ignore you. With a partner or group of classmates, recall specific examples from personal experiences to...
-
Identify the ongoing narratives in either your current family or your family of origin. Explain: a. The narrative b. When and how it is retold c. The way this narrative portrays your family d. The...
-
Consider how you manage boundaries with members of your family (immediate or extended). See if you can identify familial relationships in your life that are typified by each of these four patterns...
-
Gibb argues that spontaneous rather than strategic communication reduces defensiveness. However, in some situations a strategic approach may hold the promise of a better climate than a completely...
-
The empirical formula of lead (II) oxide was determined by passing excess dry hydrogen gas over 6.69 g of heated lead (II) oxide. a). What was the purpose of using excess dry hydrogen gas? b). The...
-
Graph the following conic sections, labeling vertices, foci, directrices, and asymptotes (if they exist). Give the eccentricity of the curve. Use a graphing utility to check your work. 10 5 + 2 cos 0
-
Bill and Guilda each own 50 percent of the stock of Radiata Corporation, an S corporation. Guilda's basis in her stock is $25,000. On July 31, 2012, Bill sells his stock, with a basis of $40,000, to...
-
Skyler is covered by his company's health insurance plan. The health insurance costs his company $3,500 a year. During the year, Skyler is diagnosed with a serious illness and the health insurance...
-
Diane is a single taxpayer who qualifies for the earned income credit. Diane has two qualifying children who are 3 and 5 years old. During 2012, Diane's wages are $17,100 and she receives dividend...
-
Derive the equations of motion for the problem of Example 6.5 using (a) Newton's second law, (b) Lagrange's equation, and (c) Hamilton's principle, and then solve for the response. Example 6.5...
-
Use Hamilton's principle to derive the equations of motion for the structures shown in Figures (a) 6.66, (b) 6.68 , and (c) 6.69 . L m 12 m2 Figure 6.66: Double pendulum.
-
For the system shown in Figure 6.13, solve for the responses where \(k_{1}=k_{2}=k_{3}=k, m_{1}=m_{2}=\) \(m\), and where the initial conditions are \(x_{1}(0)=\) \(1, x_{2}(0)=1\), and zero initial...
Study smarter with the SolutionInn App