{"id":1695,"date":"2019-04-18T18:49:06","date_gmt":"2019-04-18T18:49:06","guid":{"rendered":"https:\/\/builder-help.gjgardner.com\/?page_id=1695"},"modified":"2021-11-05T23:23:01","modified_gmt":"2021-11-05T23:23:01","slug":"markup-price-book-worksheet","status":"publish","type":"ht_kb","link":"http:\/\/help.gjgardner.com\/nz\/hc\/reports\/estimating-reports\/markup-price-book-worksheet\/","title":{"rendered":"Markup Price Book Worksheet Report"},"content":{"rendered":"

The Markup Price Book Worksheet report allows you to see the variance of the selling price of each House after applying three different cost markup percentages.<\/p>\n\n\n\n

  1. Open the library with reports.<\/li>
  2. Select Markup Price Book Worksheet<\/strong>.<\/li>
  3. Define criteria for generating the report, as follows:
    \n\n\n\n\n\n\n
    Price Book<\/strong><\/td>\nSelect the Price Book for generating the report.<\/td>\n<\/tr>\n
    Exclude Withdrawn Price Books<\/strong><\/td>\nCheck the box to exclude the withdrawn Price Books.<\/td>\n<\/tr>\n
    Cost Markup % #1, 2, 3<\/strong><\/td>\nEnter three cost markup percents to see the variance of the selling price of Houses.<\/td>\n<\/tr>\n
    Exclude Quick Quotes<\/strong><\/td>\nCheck the box to exclude Price Books that can be used for producing Quick Quotes.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    \"\"<\/figure>

    <\/p>\n<\/li>

  4. When complete, click Apply<\/strong>. The system generates the report, as follows:\"\"<\/li><\/ol>\n\n\n\n

    The report shows the following information about profit of Houses:<\/p>\n\n\n\n

    House<\/strong><\/td>Code and name of the House Plan.<\/td><\/tr>
    Cost<\/strong><\/td>Net cost of the House Plan.<\/td><\/tr>
    Selling Price<\/strong><\/td>Selling price of the House per each markup percentage applied.<\/td><\/tr>
    Profit<\/strong><\/td>Calculated profit of the House per each markup percentage applied.<\/td><\/tr><\/tbody><\/table><\/figure>","protected":false},"excerpt":{"rendered":"

    The Markup Price Book Worksheet report allows you to see the variance of the selling price of each House after applying three different cost markup percentages. Open the library with reports. Select Markup Price Book Worksheet. Define criteria for generating the report, as follows: Price Book Select the Price Book…<\/p>","protected":false},"author":21,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[55,95],"ht-kb-tag":[],"class_list":["post-1695","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-estimating-reports","ht_kb_category-needs-update"],"_links":{"self":[{"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/ht-kb\/1695"}],"collection":[{"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/comments?post=1695"}],"version-history":[{"count":2,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/ht-kb\/1695\/revisions"}],"predecessor-version":[{"id":7860,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/ht-kb\/1695\/revisions\/7860"}],"wp:attachment":[{"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/media?parent=1695"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/ht-kb-category?post=1695"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.gjgardner.com\/nz\/wp-json\/wp\/v2\/ht-kb-tag?post=1695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}