2 3 The following information pertains to Tiffany Company: 5 8 Month January February March Sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2 3 The following information pertains to Tiffany Company: 5 8 Month January February March Sales (Note 1) Cash balance, March 1st Minimum cash balance at end of each month $ $ $ SSS 9 10 Note 1: All sales are on account. Cash is collected from customers in the following manner. 11 Month of sale 40% 12 Month after sale 60% 13 14 Note 2: Purchases are paid for in the following manner. 5 Month of purchase 6 Month after purchase 7 8 Other information is as follows: 9 Labor costs as % of sales Other operating costs per month Depreciation per month $ $ $ 50,000 $ 60,000 $ 75,000 $ Inventory Purchases (Note 2) 35% 65% 15% 35.000 6,000 20,000 20,000 25,000 20,000 35,000 25 Required: Create a cash budget for the month of March (11 marks) 26 Tiffany Company Cash Budget For the month of March 27 28 Cash balance, beginning 29 Add: cash collections from customers 30 31 Cash payments: 32 Inventory purchases 33 41 34 35 36 Cash excess (deficiency) 37 Financing: 38 Borrowing 39 Repayments 40 Total financing $ 20,000 39 Repayments 40 Total financing 41 42 43 44 45 46 B 44 BONUS (1 MARK): What is the balance of accounts receivable at March 31st? 47 48 49 C O Part 2: Why would Tiffany Company want to prepare a cash budget in advance? Please give two reasons. This must be specific to this question. No marks will be awarded for generic answers. (2 marks) + E 2 3 The following information pertains to Tiffany Company: 5 8 Month January February March Sales (Note 1) Cash balance, March 1st Minimum cash balance at end of each month $ $ $ SSS 9 10 Note 1: All sales are on account. Cash is collected from customers in the following manner. 11 Month of sale 40% 12 Month after sale 60% 13 14 Note 2: Purchases are paid for in the following manner. 5 Month of purchase 6 Month after purchase 7 8 Other information is as follows: 9 Labor costs as % of sales Other operating costs per month Depreciation per month $ $ $ 50,000 $ 60,000 $ 75,000 $ Inventory Purchases (Note 2) 35% 65% 15% 35.000 6,000 20,000 20,000 25,000 20,000 35,000 25 Required: Create a cash budget for the month of March (11 marks) 26 Tiffany Company Cash Budget For the month of March 27 28 Cash balance, beginning 29 Add: cash collections from customers 30 31 Cash payments: 32 Inventory purchases 33 41 34 35 36 Cash excess (deficiency) 37 Financing: 38 Borrowing 39 Repayments 40 Total financing $ 20,000 39 Repayments 40 Total financing 41 42 43 44 45 46 B 44 BONUS (1 MARK): What is the balance of accounts receivable at March 31st? 47 48 49 C O Part 2: Why would Tiffany Company want to prepare a cash budget in advance? Please give two reasons. This must be specific to this question. No marks will be awarded for generic answers. (2 marks) + E 2 3 The following information pertains to Tiffany Company: 5 8 Month January February March Sales (Note 1) Cash balance, March 1st Minimum cash balance at end of each month $ $ $ SSS 9 10 Note 1: All sales are on account. Cash is collected from customers in the following manner. 11 Month of sale 40% 12 Month after sale 60% 13 14 Note 2: Purchases are paid for in the following manner. 5 Month of purchase 6 Month after purchase 7 8 Other information is as follows: 9 Labor costs as % of sales Other operating costs per month Depreciation per month $ $ $ 50,000 $ 60,000 $ 75,000 $ Inventory Purchases (Note 2) 35% 65% 15% 35.000 6,000 20,000 20,000 25,000 20,000 35,000 25 Required: Create a cash budget for the month of March (11 marks) 26 Tiffany Company Cash Budget For the month of March 27 28 Cash balance, beginning 29 Add: cash collections from customers 30 31 Cash payments: 32 Inventory purchases 33 41 34 35 36 Cash excess (deficiency) 37 Financing: 38 Borrowing 39 Repayments 40 Total financing $ 20,000 39 Repayments 40 Total financing 41 42 43 44 45 46 B 44 BONUS (1 MARK): What is the balance of accounts receivable at March 31st? 47 48 49 C O Part 2: Why would Tiffany Company want to prepare a cash budget in advance? Please give two reasons. This must be specific to this question. No marks will be awarded for generic answers. (2 marks) + E 2 3 The following information pertains to Tiffany Company: 5 8 Month January February March Sales (Note 1) Cash balance, March 1st Minimum cash balance at end of each month $ $ $ SSS 9 10 Note 1: All sales are on account. Cash is collected from customers in the following manner. 11 Month of sale 40% 12 Month after sale 60% 13 14 Note 2: Purchases are paid for in the following manner. 5 Month of purchase 6 Month after purchase 7 8 Other information is as follows: 9 Labor costs as % of sales Other operating costs per month Depreciation per month $ $ $ 50,000 $ 60,000 $ 75,000 $ Inventory Purchases (Note 2) 35% 65% 15% 35.000 6,000 20,000 20,000 25,000 20,000 35,000 25 Required: Create a cash budget for the month of March (11 marks) 26 Tiffany Company Cash Budget For the month of March 27 28 Cash balance, beginning 29 Add: cash collections from customers 30 31 Cash payments: 32 Inventory purchases 33 41 34 35 36 Cash excess (deficiency) 37 Financing: 38 Borrowing 39 Repayments 40 Total financing $ 20,000 39 Repayments 40 Total financing 41 42 43 44 45 46 B 44 BONUS (1 MARK): What is the balance of accounts receivable at March 31st? 47 48 49 C O Part 2: Why would Tiffany Company want to prepare a cash budget in advance? Please give two reasons. This must be specific to this question. No marks will be awarded for generic answers. (2 marks) + E
Expert Answer:
Answer rating: 100% (QA)
SOLUTION To prepare the cash budget for Tiffany Company for the month of March lets analyze the given information step by step Cash budget for the mon... View the full answer
Related Book For
Financial Reporting and Analysis
ISBN: 978-0078025679
6th edition
Authors: Flawrence Revsine, Daniel Collins, Bruce, Mittelstaedt, Leon
Posted Date:
Students also viewed these accounting questions
-
The following information pertains to Job 712 that Daichi Manufacturing Company completed during January 2014. Materials and labor costs for the job were $49,000 and $38,000, respectively. Applied...
-
The following information pertains to United Ways, a private voluntary health and welfare organization, for the year ended December 31, 20X3. Balances in net assets at January 1, 20X3: Unrestricted...
-
The following information pertains to Job 712 that Nantou Manufacturing Company completed during January 2018. Materials and labor costs for the job were $24,500 and $19,000, respectively. Applied...
-
Which of the following activity bases would best be used to allocate setup activity to products? a. Number of inspections b. Direct labor hours c. Direct machine hours d. Number of production runs
-
A call center in India used by U.S. and U.K. credit card holders has a capacity of 1,400,000 calls annually. The fixed cost of the center is $775,000 with an average variable cost of $1 and revenue...
-
On January 1, Year 1, Brown Co. borrowed cash from First Bank by issuing a $100,000 face value, fouryear term note that had an 8 percent annual interest rate. The note is to be repaid by making...
-
In Exercises 1 to 4, it may be helpful to draw a figure such as Figure 5.5. Figure 5.5. Using the normal curve table, determine the area of the standard normal distribution that is between the mean...
-
The GSS10SSDS includes a measure of highest educational degree completed (DEGREE). Test whether there is a significant difference between those with less than high school (coded 0) and those with a...
-
Cullumber Ltd. is in the business of manufacturing cabinets, computer stands, and countertops. Most of its jobs are contracts for home builders. The following information is available for the month...
-
Consider the state diagrams of Figure 12.28. a. Describe the behavior of each. b. Compare these with the branch prediction state diagram in Section 12.4. Discuss the relative merits of each of the...
-
How do you think that management can confront and resolve the issue of over utilization of diagnostic testing? Do you feel they should? Why/ why not?
-
Interviewing an elderly with quadriplegic. What did you learn from this experience? How did this interview force you to look at your own life?
-
> For a recent year, McDonald's (MCD) company-owned restaurants had the following sales and expenses (in millions): Sales Food and paper Payroll and employee benefits Occupancy and other expenses...
-
What are the intricate mechanisms underlying the phenomenon of trophic cascades, and how do they manifest within complex ecosystems ?Explain
-
Kampfire, Inc., a very successful manufacturer of camping equipment, is considering "going public" next month to raise funds to help finance the company's future growth. The financial manager of...
-
Scott places $830,000 in trust with income to Katherine (age 53) for 14 years, and remainder to Ben (age 36). Scott does not reserve any powers to alter, amend, revoke or terminate the trust....
-
Loan= 60000, origination fee=3%, i =12 %, 30 years of maturity, calculate prepayment at the end of the 5th year?
-
Use the following data to answer the next two (2) questions: Product 1 Product 2 Product 3 Direct Material Cost $25,000 $30,000 $35,000 Direct Labor Cost $30,000 $40,000 $50,000 Direct Labor Hours...
-
ESCO Technologies Inc. and Take-Two Interactive Software, Inc., both capitalize software development costs in accordance with their respective policies as summarized here. The condensed financial...
-
Metro Inc. reported net income of $150,000 for 2014. Changes occurred in several balance sheet accounts during 2014 as follows: Investment in Videogold Inc. stock, carried on the equity basis $5,500...
-
Samson Manufacturing Company, a calendar year company, purchased a machine for $65,000 on January 1, 2012. At the date of purchase, Samson incurred the following additional costs: Loss on sale of old...
-
In the 1970s, Special Electric Company brokered the sale of crocidolite asbestos, which is the most toxic form of asbestos, to Johns- Manville Corporation. Special Electric never held possession of...
-
On January 2, 2018, The Register, a science and technology news site based in Britain, published an article revealing the existence of two major bugs leaving virtually all computers and smartphones...
-
Plaintiffs W. O. and J. C. Lucy had wanted to purchase Ferguson Farm from the Zehmers for at least eight years. One night, Lucy stopped by the establishment the Zehmers operated and said that he bet...
Study smarter with the SolutionInn App