Develop the cash receipts section of the cash budget

Assignment Help Managerial Accounting
Reference no: EM132514127

Comptel International is a manufacturer of the MX7500 cell phone. The following are its sales in units for the first quarter and its anticipated sales in units for the coming quarter. The distributor price is $300 per unit.

Units

September (actual) 90,000

October (actual) 90,000

November (actual) 100,000

December (actual) 98,000

January 100,000

February 90,000

March 110,000

April 125,000

May 150,000

June 165,000

July 155,000

August 140,000

  • Comptel likes to keep 10% of the following month's sales in units in inventory. In addition, the most expensive part for the cell phone is the touchscreen. Because that part is essential and has stock-out issues, Comptel requires 25% of the following month's production requirements to be held in ending inventory. Each touchscreen costs $9.00. Inventory of touchscreens as at December 31 of the previous year was 24,750 units.
  • Comptel's customers have historically paid their account balances as follows: 15% of total sales pay cash, 20% pay in the month of purchase, 16% pay in the month following purchase, 19% pay in the second month after purchase, and 28% pay in the third month after purchase. The 2% balance remains as bad debts. The customers that paid in cash receive a 1% discount.

Required:

Question a) Develop the production budget for the MX7500 for the first quarter (January to March) and the second quarter (April to June).

Question b) Develop the purchase budget for the touchscreen for the first quarter (January to March) by each month and total quarter and second quarter (April to June) by each month and total quarter.

Question c) Develop the cash receipts section of the cash budget for the first quarter (January to March) by each month and total quarter and second quarter (January to March) by each month and total quarter.

Question d) If the accounts receivable balance at December 31 is $42,620,100, what is the accounts receivable balance (not the balance net of the allowance for doubtful accounts) at the end of June?

Reference no: EM132514127

Questions Cloud

Sustainable business environment : Describe the costs associated with not following a sustainable model and identify the benefits associated with a sustainable business environment
What should amount should the annual rent be : If Frank's charges rent annually at the beginning of the year, what should amount should the annual rent be (rounded to whole dollars)
How does the music of the baroque period : How does the music of the Baroque period differ from that of the Renaissance period? In what ways does Baroque music build on the musical elements
Determining the supporting documentation : Include at least four paragraphs, the first and second paragraph shall be a brief summary of the article in the students own words which identifies
Develop the cash receipts section of the cash budget : Develop the cash receipts section of the cash budget for the first quarter (January to March) by each month and total quarter and second quarter
Step-by-step process of conducting dismissal meeting : Describe a step-by-step process of conducting dismissal meeting. Determine the compensation that the fictitious company may provide to separated employee
Journal entries for a private-purpose trust fund : Question - Journal entries for a Private-Purpose Trust Fund. Interest income of $20,000 was received in cash from the CDs
How you will avoid the major challenges you may encounter : What are the similarities and differences between how people communicate in your culture (USA) versus communication in the country Hong Kong?
University hospital to improve hrm and hit functions : What suggestions would you provide to the senior management at University Hospital to improve HRM and HIT functions?

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Genmed hospital needs to replace its existing mri scanning

genmed hospital needs to replace its existing mri scanning machine. the hospital is considering funding the purchase by

  Provide a narrative about the approach to the problem

Provide a solution and recommended decision. Provide a narrative about the approach to the problem. Should the company buy or make the product?

  What is the annual ordering cost of the post card inventory

Cheeseburger and Taco Company purchases 18,369 boxes of cheese each year. It costs $27 to place and ship each order and $9.71 per year for each box held as inventory. What is the annual ordering cost of the post card inventory

  Determine the costs per equivalent unit for june

Determine the costs per equivalent unit for June. (Round your answers ) Compute the equivalent units for June's activity for the first department.

  Determine the cost of goods manufactured for may

Compute the amount of overhead cost that would have been applied to each project during May and determine the cost of goods manufactured for May. Show your work.

  Determine whether more people prefer coke or pepsi

Determine whether more people prefer Coke or Pepsi. Assume that roughly half the population prefers Coke and half prefers Pepsi. How large a sample do you need to take to ensure that you can estimate, with 95% confidence, the proportion of people ..

  Calculation of taxable income and current tax liability

Accounting for Corporate Entities Assignment - Prepare a schedule that shows the calculation of taxable income and current tax liability for AMC (Sales) Ltd for the year ending 30 June 2016 and provide the relevant journal entry

  Assume that oakwood wishes to increase its manufacturing

Oakwood Company produces maple bookcases to customer order

  Compute the? direct-cost rate and the? indirect-cost rate

Compute the? direct-cost rate and the? indirect-cost rate per professional? labor-hour for 2017 under? (a) actual? costing, (b) normal?costing

  Production department of a process manufacturing system

During April, the production department of a process manufacturing system completed a number of units of a product and transferred them to finished goods.

  Weighted average cost flow

Use a vertical model to show the 2013 income statement, balance sheet, and statement of cash flows under FIFO, LIFO, and weighted average.

  Calculate appropriate liquidity and financial stability rati

Calculate appropriate liquidity and financial stability ratios for the years ended 30 June 2018 and 2019. Research reveals that typical ratios in the industry

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd