Developing a Master Budget for a Merchandising Organization Peyton Department Store prepares budgets quarterly, The following information is available for use in planning the second quarter budgets for 2016, PEYTON DEPARTMENT STORE Balance Show March 31, 2010 Assets abilities and Stockholders' Equity $25,000 Mounts receh.able 25.000 Dudencs pais 17.000 101 Hwyle 1,000 Preparan 2001 Slekha pily -13,000 Flores 25 000 Tralles and 154.000 Equity 94303 Actual and forecasted sales for selected months in 2010 are as follows: Month Sales Revenue 330.000 February 50.000 ... Varth 40050 SRO 1.000 ung 70.000 Lily 311133 NU Monthly operating expenses are as follows: Windows 125,000 Depreciador 100 Udltes 1,000 Ben 1,170 Cash divicerids of $17,000 ere declared during the third month of each querter and are ped during the first months of the folosing quarter. Operating experises, except insurance, rent, and depreciation are peidas incurred. Rerit is paid during the following months. The prepaid insurance is for five more months. Cost of goods sold is equal to 50 percent of sales. Ending irreritories ere sufficient for 20 percent of the riext month's sales. Purchases during any given forth are paid in full during the following month. All sales are on account, with 50 percent collected during the month of sale, 40 percent during the next month, and 10 percent during the month thereafter. Money can be borrowed and repaid in multiples of $1,000 cl an interest rate of 12 percent per year. The corrpany desires a minimurit cash balance of $2,000 on the list of each month. At the time the principal is repeid. interest is paid on the portion of principal that is repaic. All borrowing is at the beginning of the month, and all repayment is at the end of the month. Money is never repaid at the end of the month it is borrowed. (al Prepare a purchases budget for each month of the second quarter ending June 30, 2010. Peyton Department Store Monthly Purchase Budget Quarter Ending june 29, 2010 April May June Total CS Developing a Master Budget for a Merchandising Organization Peyton Department Store prepares budgets quarterly, The following information is available for use in planning the second quarter budgets for 2016, PEYTON DEPARTMENT STORE Balance Show March 31, 2010 Assets abilities and Stockholders' Equity $25,000 Mounts receh.able 25.000 Dudencs pais 17.000 101 Hwyle 1,000 Preparan 2001 Slekha pily -13,000 Flores 25 000 Tralles and 154.000 Equity 94303 Actual and forecasted sales for selected months in 2010 are as follows: Month Sales Revenue 330.000 February 50.000 ... Varth 40050 SRO 1.000 ung 70.000 Lily 311133 NU Monthly operating expenses are as follows: Windows 125,000 Depreciador 100 Udltes 1,000 Ben 1,170 Cash divicerids of $17,000 ere declared during the third month of each querter and are ped during the first months of the folosing quarter. Operating experises, except insurance, rent, and depreciation are peidas incurred. Rerit is paid during the following months. The prepaid insurance is for five more months. Cost of goods sold is equal to 50 percent of sales. Ending irreritories ere sufficient for 20 percent of the riext month's sales. Purchases during any given forth are paid in full during the following month. All sales are on account, with 50 percent collected during the month of sale, 40 percent during the next month, and 10 percent during the month thereafter. Money can be borrowed and repaid in multiples of $1,000 cl an interest rate of 12 percent per year. The corrpany desires a minimurit cash balance of $2,000 on the list of each month. At the time the principal is repeid. interest is paid on the portion of principal that is repaic. All borrowing is at the beginning of the month, and all repayment is at the end of the month. Money is never repaid at the end of the month it is borrowed. (al Prepare a purchases budget for each month of the second quarter ending June 30, 2010. Peyton Department Store Monthly Purchase Budget Quarter Ending june 29, 2010 April May June Total CS