Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=19)
-   -   Prepare a cost of goods sold budget (https://www.askmehelpdesk.com/showthread.php?t=771867)

  • Oct 19, 2013, 07:38 AM
    victoriamjy
    Prepare a cost of goods sold budget
    Expected sales are:
    Units
    July 14700
    August 15120
    September 15680
    October 16240
    Each month's closing inventory is to be 150% of the following month's cost of sales. Average selling price is $30 per unit. Average cost of purchases as $20 per unit.
    How to calculate cost of sales of each month?
  • Oct 20, 2013, 05:14 AM
    rehmanvohra
    Cost of goods sold = sales - gross profit
    14700 * (30-20) = 147000
    Now based on sales you can work out purchases for each month. Foer example for June
    Sales 14700 units
    +Ending inventory 15120 * 1.5
    - Beginning inventory 14700 * 1.5
    =16125 units

    Now you can work out COGS budget for each month for each month/

  • All times are GMT -7. The time now is 12:22 AM.