PART A DS Pharmacy sells a product that has a highly seasonal variation with peak sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
PART A DS Pharmacy sells a product that has a highly seasonal variation with peak sales occurring in the third quarter. The following information was given for expected sales data for the coming year 2020. The product of the pharmacy sells for $6.00 per unit. Budgeted sales for the next four quarters are as follows: - Quarters Budgeted Sales in Units i. 1 ii. 2 2020 Sales are collected in the following pattern: 60% in the quarter the sales are made and the remaining 40% in the following quarter. iv. 3 4 On January 1, 2020, the records showed 60 000 in accounts receivables as well as the following information. 50 000 70 000 120 000 60 000 Equipment was purchased in the first quarter for $50 000.00. Equipment purchases increased in the second quarter by 30%. No other equipment was purchased. iii. A dividend of $16 000.00 is to be paid in the first quarter and fourth quarter only. Administration Expenses rose by 25% in the second quarter, 20% in the third, quarter and 10% in the fourth quarter. The increased in expenses was based on the previous quarter figures. Cash balance at January first was $38 000.00. Also, in the first quarter direct material cost $70 000.00, direct Labour cost $80 000.00, Administration expenses $100 000.00, Taxes $10 000.00 and Advertising $15 000.00. V. vi. vii. Page viii For financing purposes, a loan of $85 000.00 was received in the first quarter and $40 000.00 in the second quarter. In the third quarter the $85 000.00 loan with interest of $3 000.00 were repaid and in the fourth quarter the $40 000.00 loan with interest of $6 000.00 were repaid. Direct materials and Direct labour increased each quarter by $15 000 and 10 000 respectively. Rent was charged at $ 20 000.00 quarterly. Required (i) Sales budget. (ii) Schedule of cash collections (iii) Cash budget (15 marks) PART A DS Pharmacy sells a product that has a highly seasonal variation with peak sales occurring in the third quarter. The following information was given for expected sales data for the coming year 2020. The product of the pharmacy sells for $6.00 per unit. Budgeted sales for the next four quarters are as follows: - Quarters Budgeted Sales in Units i. 1 ii. 2 2020 Sales are collected in the following pattern: 60% in the quarter the sales are made and the remaining 40% in the following quarter. iv. 3 4 On January 1, 2020, the records showed 60 000 in accounts receivables as well as the following information. 50 000 70 000 120 000 60 000 Equipment was purchased in the first quarter for $50 000.00. Equipment purchases increased in the second quarter by 30%. No other equipment was purchased. iii. A dividend of $16 000.00 is to be paid in the first quarter and fourth quarter only. Administration Expenses rose by 25% in the second quarter, 20% in the third, quarter and 10% in the fourth quarter. The increased in expenses was based on the previous quarter figures. Cash balance at January first was $38 000.00. Also, in the first quarter direct material cost $70 000.00, direct Labour cost $80 000.00, Administration expenses $100 000.00, Taxes $10 000.00 and Advertising $15 000.00. V. vi. vii. Page viii For financing purposes, a loan of $85 000.00 was received in the first quarter and $40 000.00 in the second quarter. In the third quarter the $85 000.00 loan with interest of $3 000.00 were repaid and in the fourth quarter the $40 000.00 loan with interest of $6 000.00 were repaid. Direct materials and Direct labour increased each quarter by $15 000 and 10 000 respectively. Rent was charged at $ 20 000.00 quarterly. Required (i) Sales budget. (ii) Schedule of cash collections (iii) Cash budget (15 marks)
Expert Answer:
Answer rating: 100% (QA)
i Sales Budget Quarter 1 2 3 4 ii Schedule of Cash Collections Quarter 1 2 3 4 Quarter 1 2 Budgeted ... View the full answer
Related Book For
Financial Reporting and Analysis
ISBN: 978-1259722653
7th edition
Authors: Lawrence Revsine, Daniel Collins, Bruce Johnson, Fred Mittelstaedt, Leonard Soffer
Posted Date:
Students also viewed these finance questions
-
What operational changes would you recommend to Wally to improve performance? Wally Meyer deftly balanced his office keys and a large printout of forecasting data as he wheeled his mountain bike...
-
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...
-
Through the use of strategic alternatives, companies may compete in a marketplace, achieve its vision, or if no vision has been articulated, decide where it might go and what it might achieve....
-
Why does the size of a country's GDP matter? How does it affect the quality of life of the country's people?
-
Suppose that you have created a program with only the following variables. int a = 5; int b = 6; Suppose that you also have a method with the following header: public static void mathMethod(int a)...
-
The IRR of this investment is located at which point? a. A b. C c. D d. E
-
Sedgwick Company at December 31 has cash $20,000, noncash assets $100,000, liabilities $55,000, and the following capital balances: Floyd $45,000 and DeWitt $20,000. The firm is liquidated, and...
-
Suppose the 3-month interest rate (i) is 4%/year in New York and 8% in Frankfurt, and the $/ FD = 2%/year. A US investor would then invest in Frankfurt by purchasing spot and at the same time selling...
-
The Electret microphone AUM-5047L we will use can be modeled as a Norton current source, with DC current IMIC as shown below. We need to set up its DC operating point correctly, by an appropriate...
-
How the red cross-agency will respond to catastrophes such as a pandemic, massive earthquake, or bioterrorism event? what key issues did they decide when planning for each type of event from the...
-
How does your leadership, coaching, and conflict management styles (core/adaptive leadership, collaborating conflict management style) work together as you lead and coach others?
-
How does acquisition planning help the COR get the best value for acquisition? It allows the COR to give new work to Contractors with whom they have worked before. It allows the COR to identify the...
-
7. A new composite material has been developed -- iron reinforced PVC (polyvinyl chloride). The following test results were obtained: Tissue Culture Cell growth normal in culture of muscle cells ...
-
Precision Bearings Inc. makes two bearings, B100 and B200, for use in its own production. Data regarding these two bearings follow: B100B200Machine hours required per unit2.53.0Cost per unit: Direct...
-
Human tissue. Who owns bone, sinew, corneas, and other saleable body parts? Who can consent to its post-mortem removal? What do state statutes say about the nonconsensual removal of human tissue? Why...
-
Assume you are a practicing tax professional, and your client has questions about starting a new business. Your client is curious about the limited liability company (LLC) and wants to know whether...
-
Provide a draft/outline of legal research involving an indigenous Canadian woman charged with assault causing bodily harm under (Sec 267b) of the Criminal Code, where the crown wants a 12-month jail...
-
The following information pertains to Seda Company's pension plan for 2017: Actuarial estimate of projected benefit obligation at 1/1..........$72,000 Service...
-
Princess Retail Stores started doing business on January 1, 2017. The following data reflect its inventory purchases and sales during the year: Required: 1. Compute gross margin and cost of ending...
-
For the month of December 2017, Ranger Corporation's records show the following information: Cash received on accounts receivable......................$35,000 Cash...
-
Design a fast LOT-based filter bank with at least eight sub-bands.
-
Prove the relationship in Equation (9.210). CC2=CC = 0, (9.210)
-
Show that the relations in Equations (9.256)-(9.258) are valid. E(z) = [C3+2 (I - 3)]4. (9.256)
Study smarter with the SolutionInn App