Question

In: Finance

Pizza di Joey operates several food trucks that provide hot food and beverages in the Washington...

Pizza di Joey operates several food trucks that provide hot food and beverages in the Washington DC area. The company has annual sales of $625,400. Cost of goods sold average 32 percent of sales and the profit margin is 4.5 percent. The average accounts receivable balance is $34,700. Assume 365 days per year. [Please show your work on an Excel sheet]

a. On average, how long does it take the company to collect payment for its services?

b. What is the change in the Payables deferral period if the payables turnover has gone from an average of 10.50 times to 11.45 times per year?

c. What is the length of the company's cash conversion cycle after the change in the Payables deferral period if the inventory turnover is 22.20 times?

Solutions

Expert Solution

(a)-The number of days taken by the company to collect payment for its services

Average Collection period = Average accounts receivables / Sales per day

= $34,700 / [$625,400 / 365 Days]

= $34,700 / $1,713.42 per day

= 20.25 Days

(b)-Change in the Payables deferral period if the payables turnover has gone from an average of 10.50 times to 11.45 times per year

Payables deferral period if the payables turnover ratio is 10.50 Times = Number of days in a year / payables turnover ratio

= 365 Days / 10.50 Times

= 34.76 Days

Payables deferral period if the payables turnover ratio is 11.45 Times = Number of days in a year / payables turnover ratio

= 365 Days / 11.45 Times

= 31.88 Days

Therefore, the Change in the Payables deferral period = 34.76 Days – 31.88 Days

= 2.88 Days

(c)-The length of the company's cash conversion cycle after the change in the Payables deferral period if the inventory turnover is 22.20 times

Days sales in Inventory = Number of days in year / Inventory turnover ratio

= 365 Days / 22.20 Times

= 16.44 Days

Therefore, the Cash Conversion Cycle = Average Collection Period + Days sales in Inventory - Accounts Payables Deferral Period

= 20.55 Days + 16.44 Days – 31.88 Days

= 4.81 Days


Related Solutions

Pizza di Joey operates several food trucks that provide hot food and beverages in the Washington...
Pizza di Joey operates several food trucks that provide hot food and beverages in the Washington DC area. The company has annual sales of $625,400. Cost of goods sold average 32 percent of sales and the profit margin is 4.5 percent. The average accounts receivable balance is $34,700. Assume 365 days per year. a. On average, how long does it take the company to collect payment for its services? b. What is the change in the Payables deferral period if...
4. Pizza di Joey operates several food trucks that provide hot food and beverages in the...
4. Pizza di Joey operates several food trucks that provide hot food and beverages in the Washington DC area. The company has annual sales of $625,400. Cost of goods sold average 32 percent of sales and the profit margin is 4.5 percent. The average accounts receivable balance is $34,700. Assume 365 days per year. a. On average, how long does it take the company to collect payment for its services? b. What is the change in the Payables deferral period...
Mexicali On the Go Inc. owns and operates food trucks (mobile kitchens) throughout the west coast....
Mexicali On the Go Inc. owns and operates food trucks (mobile kitchens) throughout the west coast. The company’s employees have varying wage levels depending on their experience and length of time with the company. Employees work 8-hour shifts and are assigned to a truck each day based on labor needs to support the daily menu. One of its trucks, Donna’s Mobile Fiesta offers a single menu item that changes daily. On May 6, the truck prepared 150 of its most...
Building a Balanced Scorecard Hit-n-Run Inc. owns and operates 10 food trucks (mobile kitchens) throughout metropolitan...
Building a Balanced Scorecard Hit-n-Run Inc. owns and operates 10 food trucks (mobile kitchens) throughout metropolitan Los Angeles. Each food truck has a different food theme, such as Irish-Mexican fusion, traditional Mexican street food, Ethiopian cuisine, and Lebanese-Italian fusion. The company was founded three years ago by Juanita O’Brien when she opened a single food truck with a unique menu. As her business has grown, she has become concerned about her ability to manage and control the business. O’Brien describes...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT