{"id":126007,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/prepare-quarter-budgeted-income-statement"},"modified":"2017-08-16T06:07:27","modified_gmt":"2017-08-16T06:07:27","slug":"prepare-quarter-budgeted-income-statement","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/prepare-quarter-budgeted-income-statement\/","title":{"rendered":"Prepare quarter & budgeted income statement"},"content":{"rendered":"
\n

\u2022 Prepare operating budgets for the year by quarter & budgeted Income Statement for the Candy business
\u2022 Sales Information:<\/p>\n

o Company advertises that it will match the competition (Internal factor)
o Five year historical selling total units per year: 175k, 210k, 185k, 196k, & 187k
o Surrounding shopping area includes discount stores (i.e. Target, Walmart) selling similar product for $10, $12 respectively (external factor)
o Stock Market down 25% in last 3 months, oil per barrel at record low (external factor)
o Prepare a budget after choosing one of the following sales units and selling price:<\/p>\n

\u2013 Sales in units Q1 \u2013 110,000, Q2 \u2013 80,000, Q3 \u2013 120,000, Q4 \u2013 20,000
\u2013 Sales in units Q1 \u2013 10,000, Q2 \u2013 20,000, Q3 \u2013 15,000, Q4 \u2013 30,000
\u2013 Sales in units Q1 \u2013 60,000, Q2 \u2013 40,000, Q3 \u2013 10,000, Q4 \u2013 80,000
\u2013 Selling price per unit $5, $10, or $15<\/p>\n

o Document why you made the decision of units and price that you did<\/p>\n

\u2022 Production information:<\/p>\n

o Company\u2019s desired level of ending finished goods inventory is 15% of next quarters budgeted unit sales.<\/p>\n

o Q1 beginning inventory would be PY Q4 ending. Which means that when calculating Q4 PY ending you would look at CY Q1 sales units. (For example if you choose the 3rd option, Q1 sales would be 60,000, so PY Q4 ending which would be CY Q1 beginning would be 60,000 * 15% = 9,000)<\/p>\n

o When calculating Q4 ending you would need to know next years Q1 sales units. It is estimated that Q1 sales units for the following year will be a 10% increase to current year Q1. (For example if using the 3rd option, Q1 sales of the CY is estimated to be 60,000, so if next years Q1 is estimated to be 10% higher it would be 60,000 * 110% or 66,000)<\/p>\n

\u2022 Direct materials information:
o 16 ounces (oz) of chocolate per unit
o Chocolate costs $.20 per ounce (oz)
o Company\u2019s desired level of ending material inventory is 20% of next quarters budgeted direct material needs.
o Q1 beginning use the same method as used during the production budget.
o Q4 ending use the same method as used during the production budget.<\/p>\n

\u2022 Direct labor information:
o Twelve minutes per unit (12 minutes\/60 minutes = .2\/hr per unit)
o Employees are paid $8\/hour<\/p>\n

\u2022 Overhead information:
o Production supervisor salary for the year is $32,000
o Machinery depreciation for the year using straightline is $11,500
o Factory supplies is $1.50 per DL hour
o Maintenance & repairs is $2.00 per DL hour
o Utilities is $3.00 per DL hour<\/p>\n

\u2022 Selling, General & Administrative (SG&A) information:
o Executive salary for the year is $55,000
o Taxes & insurance for the year is $7,200
o Delivery expense is $.35 per sold unit
o Other administrative expenses is $.05 per unit sold<\/p>\n

\u2022 Cost of Goods Manufactured information:
o WIP, beginning $237,600 & ending $193,405<\/p>\n

\u2022 Income Statement
o Income tax 34% on net income before taxes (NIBT)<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u2022 Prepare operating budgets for the year by quarter & budgeted Income Statement for the Candy business \u2022 Sales Information: o Company advertises that it will match the competition (Internal factor) o Five year historical selling total units per year: Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-126007","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/126007","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=126007"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/126007\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=126007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=126007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=126007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}